Emailed DataSet date conversion

rado98

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

david_cunningham

You can specify the date format as an option argument in the config of the connector.

https://domo-support.domo.com/s/article/360042931954?language=en_US

david_cunningham

You can specify the date format as an option argument in the config of the connector.

https://domo-support.domo.com/s/article/360042931954?language=en_US

rado98

Found it!! Thanks

I think I need to wait until the next email to confirm that it works