Error 44580 upon importing a date field

Using my Dolibarr CRM/SRM Modules
1

I am trying to import a (Csv or xlsx) file where one field is a Date field. But Dolibarr keeps on complaining with error 44580 regarding the format.

I have tried both known format: 2022/01/19 as well as 01/19/2022 and the error remains the same (tried also 1/19/2022 (ironically in the database it is stored as 2022/01/19 after I entered it manually but upon import it doesn’t work.,

Can somebody please provide an answer, short of me making it a string field?

2

SOLVED

After further experimentation it has turned out that if I use the EXCEL formatting for date yyyymmdd then it works. So this is European Format without any separators (“-” or “/”)