Importing a date column in DD-MM-YYYY format not working

Ask for Help
1

I am using import file to import an csv…

A col in the csv is a date in the format of dd-mm-yyyy.

Problem is grist insists on interpreting this col as MM-DD-YYYY on input. Nothing I do seems to be able to tweak the date to the proper format on input.

Tried a few things… tweaking the col to string, any or date, and re-importing. Results are strange to say the least…
here is a sample row:

AutoName,FestivalDate,Garden,Slot
“Martin,Carlene”,04-10-2024,Avila,AM

any help is appreciated.

2

Hi there,

Are all the dates in the CSV between 1 and 12? This could be what is causing the confusion of which is month and which is date. Could you add a test row to the CSV with the date 31-10-2024? This way, it’ll recognize that the format is DD-MM-YYYY.

Thanks,
Natalie

3

yes… good catch. I can try your workaround.
Would be better if you can hint the export which date format to use on import.
Just a suggestion.