Some dates importing incorrectly through Data Shuttle

atombee

I am uploading data onto Smartsheet through Data Shuttle from a CSV file. I have a date column and have confirmed most dates are importing correctly, however there are instances where the day and month are swapped.

i.e. the date on the CSV file reads 12/04/24 (DD/MM/YY), but is added to the Smartsheet as 04/12/24. I've noticed that the error only occurs if the DD is the 12th in the YY 2024.

Yvonne Smythe

Hi @atombee - I found a possible solution from a previous discussion that’s similar to yours. Creating a helper column to consume or hold the data (as is) without any date constraints seems like it would work.

Previous Discussion:

https://community.smartsheet.com/discussion/93797/data-shuttle-and-date-format