Emailed DataSet date conversion

Options
rado98
rado98 Contributor

Hi

I have a DataSet that get updated via the email connected. The data includes a date column, I am having issues with the automatic date conversion on the DataSet. See below an example for the data in the CSV file, both dates are on March 2024

2577,Benjamin,12/03/2026 date gets converted automatically and incorrectly to 3 Dec 2024

2589,Luke,26/03/2026 date gets converted automatically and correctly to 26 March 2024

Any idea how to fix this? Either at DataSet setup level or ETL.

If there is an instance date setting it would already be in dd/mm/yy format for Australia

Best Answer

Answers