Day-first or month-first? Cleaning a column of dates like 03/04/2025

A date like 03/04/2025 reads as the 3rd of April in Europe and as the 4th of March in the United States. One cell cannot tell which; the column can. A single 15/04/2025 in the same column proves that the first number is the day, because there is no 15th month.

Column type: DATE

In the fileCleanedStatus
03/04/20252025-04-03ambiguous
15/04/20252025-04-15clean
28/02/20252025-02-28clean
01/12/20242024-12-01ambiguous
09/10/20242024-10-09ambiguous

What happened

Data Cleaner reads the column as a whole, settles the order from the cells that can only be read one way, and writes every date as ISO 8601 (YYYY-MM-DD). The cells that would have read differently the other way round keep a flag, is_ambiguous, so a reader can check them; the order chosen is the column's, not a guess per cell.

Do it yourself

curl -X POST https://data-cleaner.com/clean/v1/column \
  -H 'Content-Type: application/json' \
  -d '{"values": ["03/04/2025", "15/04/2025", "28/02/2025", "01/12/2024", "09/10/2024"]}'

The answers above are the API's own, captured when this page was built.

More guides