Importing Dates not working

[Dart Humeston]

Importing excel, everything works but submit date and received date. error is "Text '03'25'24' could not be p........The rest of the message is missing....Using Windows desktop version. 

Thanks!

[Er Mo]

Hallo

Meisten ist liegt der Fehler beim " Trennzeichen " . Das wirt zum Trennen der einzelnen Feldinhalten verwendet und darf im " normalen " Text nicht vorkommen . Man kann in Excel und in Memento das Trennzeichen umstellen . Versuche das mal

Hello
The error usually lies with the "delimiter." This is used to separate the individual field contents and should not appear in "normal" text. You can change the delimiter in Excel and Memento. Try that.

Ernst

[David Gilmore]

Also note that the order of the values is area/country dependent. Here in the US its MM/DD/YYYY, where in other areas it is often DD/MM/YYYY. I also like to make the year 4 digits, to lessen the ambiguity.

Like Enst said, Microsoft Excel is an excellent tool to load up the CSV file and change the date column format. Try exporting a dummy record in Memento to see what Memento likes for date formatting.