Short Answer: Check that you've selected the correct 'Transaction date' column, the correct 'Header row', and the right order under '3. Date format' (First/Second/Third value).
PreRequisites
-
You can view the original date strings in 'Data preview (20 rows)'
-
You have access to the '3. Date format' controls
Steps
-
Confirm the correct column is selected under '2. Transaction date' (for example 'Post Date').
The transaction date column matches the preview column containing dates. -
Verify 'Header row' points to the correct header row so column names are detected properly.
Column headers display correctly in the data preview. -
Set the '3. Date format' 'First value', 'Second value', and 'Third value' to match the order shown in the date text (Day, Month, Year or other).
Date format matches the string structure of your dates. -
Check 'Formatted preview (first 5 rows)' to confirm that dates now appear correctly.
Preview shows correctly parsed dates.
Troubleshooting
- Dates still incorrect after changing format.
LikelyCause: Date strings include unexpected separators or nonstandard text (e.g., time stamps or notes in the same cell).
Action: Inspect the original file to ensure the date column contains only date values in a consistent format, then re-import or correct the source file so the date parser can apply the chosen format.
Note: The helper text 'Select the order of day, month, and year in your date column.' is shown under 'Date format'.