Question

The date is reduced by one day after the Exel import

1

I use excel importer to import objects into entities. But the importer does something strange with dates, it seems it decreases any date by one day. So this 1/1/1900 0:00:00 becomes this 12/31/1899. How can I fix it? UPD I tried to use AddDays function, but it show me an error “The following error occurred when importing document: java.text.ParseException - Unparseable date: "1899-12-31"”

asked 2021-05-17

Maxim Velichkin

1 answers

Andreas Blaesius · Answer 1 · 2021-05-17

I guess this has to do with localized and/or non localized date attributes.

Is your date attribute set to localized or to non localized? Because a date without time component is always stored as 12:00 AM UTC. If you have an offset to UTC in one direction, it seems fine. An offset to UTC in the other direction will cause your issue.