Bug when importing Excel files. 01.01.2020 -> 12/31/2019

0
Hello, everyone, I'm testing an Excel import  (by “Excel-Importer”) now and everything went fine. But only I found the date "01.01.2020" was recognized as "12/31/2019" although three dates before were recognized correctly.     My Excel looked like this:   recognized as such:   Domain model:
asked
1 answers
0

First, add two columns next to Date, the first showing format DateTime, the second showing date in the UTCtime.

Second, have a look at the database-content. You will probably see the dates being set in the database using UTC and probably one day earlier because of the difference in timezone since your excel is German.

That explains the last of the four dates. Why the first three end up with the correct date is actually a bigger mystery. Although Ronald Caterels correctly points out that the first three are dates in the summertime.

What is the date setting in your project at Project settings->Language->edit Language->Date format. Or are you having a date parser at the Date-field?

answered