Date format for file import

Hello
I am still not able to import a 3rd party file, because Dolibarr will not accept the date format they give in their example download file.
Has anyone else experienced this problem, and found an answer to it please?
The error I am getting :
* Line 2
> Wrong value for field number 33 (value ‘20/03/2015’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
Thanks,
Elizabeth :unhappy:

I’ve finally found the answer, and here it is in case other users are having the same problem.

In the csv upload file you need to ensure the format of the date column is set to 2015-03-14. (format cells / date/ 2014-03-14).

1 Like

Brilliant!! You saved me a lot of time, thanks!