How to use this tool
- Import the file and inspect the date column. Look for a value with a day greater than 12 or check the export settings of the source system.
- Select the column and the input date order. Compare several source dates with the proposed results.
- Apply the conversion and review any invalid dates that remain. Check the original record before correcting an impossible day or month.
Worked examples
| Original data | After review |
|---|---|
| 31/01/2025 · day/month/year | 2025-01-31 |
| 03/04/2025 · month/day/year | 2025-03-04 |
Frequently asked questions
Can the tool determine the order from 03/04/2025?
That value alone fits both common date orders. Confirm the convention with the file owner or use an unambiguous value from the same source.
What should I do with 2025-02-29?
2025 has 28 days in February. Consult the source record to choose the correction. Changing the display format cannot determine the intended date.
