Date wrong

[MRohweder]

On Dolibarr 14 is an problem with the imported Date

Value Date and Transaction date are 1970 after import.
at import mask date shown correctly.

[hanneshier]

Did you found a solution for that bug?

[hanneshier]

Did you found a solution for that bug?

For me it was just entering the wrong date format 🤦 I was using the standard d/m/Y instead of d.m.Y

[MRohweder]

No thats not on my side.
i use the %d.%m.%y as seen inside csv file.
I can import the file and on page where i can select what kind of transaction each line is, everything works.
But than i create transactions.
And after that at transaction overview all date files are like this.

[hanneshier]

i use the %d.%m.%y as seen inside csv file.

How many digits does your year representation have? Because for four digit year representation, it has to be an uppercase Y.

There is more information in this article.

Also, I don't use their % sign, but I don't know if that makes any difference 🤷

[glu000]

I have the same problem. Analysing the source-code shows that the module is using str_getcsv. This function is not working when using standard German locale settings. See https://www.php.net/manual/de/function.str-getcsv.php

By the way: As the module is using the function DateTime::createFromFormat to parse the date, you should'nt use % in the format string. So it should be d.m.Y for standard German dates

[mnrbig]

Hi,

This is still an issue on Dolibarr 19 and changing formats doesn't solve it. Does anyone have other ideas as to what may be causing it?

Thanks