# Date format for file import **URL:** \ **Category:** Using my Dolibarr\ **Created:** [March 20, 2015, 5:06pm UTC](https://www.dolibarr.org/forum/t/date-format-for-file-import/11944 "2015-03-20T17:06:58Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Elizabeth](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/e/34f0e0/32.png) [@Elizabeth](https://www.dolibarr.org/forum/u/Elizabeth)\ **Post date:** [March 20, 2015, 5:06pm UTC](https://www.dolibarr.org/forum/t/date-format-for-file-import/11944/1 "2015-03-20T17:06:58Z")
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: ---
**Author:** ![Elizabeth](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/e/34f0e0/32.png) [@Elizabeth](https://www.dolibarr.org/forum/u/Elizabeth)\ **Post date:** [March 22, 2015, 9:42am UTC](https://www.dolibarr.org/forum/t/date-format-for-file-import/11944/2 "2015-03-22T09:42:12Z")
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). ---
**Author:** ![m.craven6](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/848f3c/32.png) [@m.craven6](https://www.dolibarr.org/forum/u/m.craven6)\ **Post date:** [October 7, 2021, 4:51am UTC](https://www.dolibarr.org/forum/t/date-format-for-file-import/11944/3 "2021-10-07T04:51:55Z")
Brilliant!! You saved me a lot of time, thanks! ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [October 7, 2021, 9:17am UTC](https://www.dolibarr.org/forum/t/date-format-for-file-import/11944/4 "2021-10-07T09:17:36Z")