Certrow

Validate / CPSC eFiling date format converter

CPSC eFiling date format converter

Manufacture Date is a month and year. Last Test Date and the production dates are full dates. Type a date as you have it.

Template V3 columnFormatExample
Manufacture DateMM/CCYY06/2026
Last Test DateMM/DD/CCYY06/20/2026
Production Start DateMM/DD/CCYY06/01/2026
Production End DateMM/DD/CCYY06/14/2026

Source: Field Details, CPSC User Guide for CSV Upload V3 (December 2025). CC is the century: CCYY is the four-digit year.

What common spellings turn into

As typedManufacture Date (MM/CCYY)Last Test Date (MM/DD/CCYY)
2026-06-2006/202606/20/2026
6/20/202606/202606/20/2026
06/20/202606/202606/20/2026
20/06/2026Refused: "20/06/2026" is not a month and year.Refused: "20/06/2026" reads as day/month/year.
03/08/26Refused: "03/08/26" is not a month and year.Refused: "03/08/26" has a two-digit year.
Jun 202606/2026Refused: "Jun 2026" is not a date.
2026-0606/2026Refused: "2026-06" is not a date.
06/202606/2026Refused: "06/2026" is not a date.
45828Refused: "45828" is not a month and year.Refused: "45828" looks like an Excel date number, not a date.
  • A day-first date such as 20/06/2026 is refused, not swapped, when it cannot be a month-first date. 03/04/2026 is read month-first: check dates copied from factory paperwork.
  • 45828 is how Excel stores a date internally. Format the column as Text before typing.
  • The converter is the same code the file validator runs on every row. Reading 2026-06-20 or Jun 2026 is this site's convenience; CPSC's guide names only the two formats above.

Check every date in a file

Questions

What date format does CPSC eFiling use for Manufacture Date?

MM/CCYY, the month and four-digit year, for example 06/2026. CPSC's CSV guide describes it as the month and year the product was manufactured.

What date format does Last Test Date use in the CPSC eFiling CSV?

MM/DD/CCYY, for example 06/20/2026. Production Start Date and Production End Date use the same format.

Related