I have looked through similar threads but I get none the wiser. I’m obviously missing something.
First off Excel refuses to save the .csv file with comma separators so I have to open the file in text edit and replace the “;” with “,”.
I have tried setting the date cell in excel the same format as in manager before saving it as .csv.
I still get the same error. “Year, Month, and Day parameters describe an un-representable DateTime.”
When I open the file in texedit it looks ok, if I import it again to excel the date format is off slightly, but I guess that is because excel puts it in whatever is the default format when it’s imported from csv.
Any help would be greatly appreciated!