I'm stuck getting an excel timestamp imported.
Timestamp in excel is formatted like DD.MM.YYYY hh:mm:ss:
Timestamp number looks like this in excel:
If I try to import the data into Qlik via dataeditor, the timestamp looks like this:
It's the same row, just 4 years and 1 day earlier.
The imported timestamp number looks like this in qlik:
I searched the web for about 2 hours now but couldn't find a solution.
Did someone have the same issue and could solve it?
Excel format is XLS (97-2003)