Date error msg: "couldn’t convert date field, should be of type timestamp" | panthea tzourio | 2020-08-18 06:09 |
Status: Active | ||
Merci for your time Chet. As for your question suggestion :"to add "CET" for the timezone in your data", I'm not sure I understand exactly what you want me to do. I must say I've tried everything possible: even rewritten manually the dates in any possible format, American or French. The problème is Java overwrites the system date (CEST), whatever the files date format or the Study folder date format be. I just even tried to add a vba Module to a rejected excel file to force the CET time instead of the system CEST. Please see the Notepad file attached. No change in the outcome. Still CEST timezone is read. Same error msg with our own research data or Labkey demo data. The odd thing is that this Java behaviour with european time zone is not the same from file to file! Demographics.xls file with an identical Date field format is imported to Labkey server while the same structured file LabResults.xls produces the CEST error msg! Maybe in the first, the system is not parsing on date while in the second it does. |
||