How do I set the date format so the system reads my dates correctly?

Short Answer: Under '4. Date format' set 'First value', 'Second value', 'Third value' to match the order of day, month, and year in your date column (example: Day, Month, Year).

PreRequisites

1. '3. Transaction date' selected

2. '2. Header row' set correctly

Steps

1. Locate '4. Date format' in the Required fields panel.
   '4. Date format' shows 'First value', 'Second value', 'Third value' controls.

2. Set 'First value', 'Second value' and 'Third value' to the correct order for your file (options include Day, Month, Year).
   The selected order matches your spreadsheet date format.

3. Read the helper text 'Select the order of day, month, and year in your date column.' to confirm the change.
   You have chosen the correct D/M/Y or M/D/Y order.

4. Verify dates in 'Data preview (20 rows)' now display and parse as expected.
   Dates appear correctly parsed in the preview.

Troubleshooting

1. Dates still show wrong values after changing the order.
   LikelyCause: Date column contains mixed formats or non-standard separators, or the wrong transaction date column is selected.
   Action: Confirm '3. Transaction date' points to the intended column and inspect a few raw date cells in your source file; normalize mixed formats in the source or choose the alternate order that matches most rows.

Note: Start with the most common order used in your region (e.g., Day/Month/Year) and adjust if preview shows mismatches.