Excel Importer Question

0
Dears, When we importing an excel sheet using (Excel Importer) module to import a list including a date column, everything is okay except if the date is 31/12/YYYY, it will be imported as 31/12/YYYY +1, for example, 31/12/2020 it will be imported as 31/12/2021, and so on. The issue is happening only in our production environment, on the local machine, it is working correctly.
asked
2 answers
0

You are probably using a date format somewhere. Instead of ‘YYYY’ try to use ‘yyyy’.

See http://dangoldin.com/2019/01/06/javas-simpledateformat-yyyy-vs-yyyy/ for more info.

 

answered
0

I've checked its value used ‘yyyy’.

answered