Date format changing when uploading csv data shuttle when DD is lower than 13

Options

The only part that has changed for us is a new Microsoft Office Tenant - Office 365 we have checked all regional date format settings. Here's an example row no 8 in the csv exel the raw data shows the date as 6th January 2023 which is correct. The column format is date.

When uploading the data via data shuttle. The sheet transposes this to 1st June 2023.


Answers