When using the dataimporter module, if I import from an xls file that has dates formatted to a date value (but when they are formatted as plain text, are in the form of a number like 17003), then jmix imports them incorrectly.
If the date in excel is 23/02/1955, then jmix imports it as American short-form 2/23/55.
This is a problem because I don’t know if the 55 is 1955 or 2055!
Does anyone know how to work around this?
Hello,
it can help if you tell us what version of Jmix are you using, and what data import module?
I presume it’s this one?
Looking at the problem from another end, have you experimented with different date formats or e.g.columns defined as a date on the excel file side?
So would a quick fix be to format that column and then give it to the import the way it likes it?
Did you try to save as xlsx or csv and then import?
Kind regards,
Mladen