# Error 44580 upon importing a date field

**URL:** <https://www.dolibarr.org/forum/t/error-44580-upon-importing-a-date-field/23323>\
**Category:** CRM/SRM Modules\
**Tags:** Help\
**Created:** [January 31, 2023, 2:30am UTC](https://www.dolibarr.org/forum/t/error-44580-upon-importing-a-date-field/23323 "2023-01-31T02:30:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AXELTI54](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/axelti54/32/5885_2.png) [@AXELTI54](https://www.dolibarr.org/forum/u/AXELTI54)\
**Post date:** [January 31, 2023, 2:30am UTC](https://www.dolibarr.org/forum/t/error-44580-upon-importing-a-date-field/23323/1 "2023-01-31T02:30:54Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![AXELTI54](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/axelti54/32/5885_2.png) [@AXELTI54](https://www.dolibarr.org/forum/u/AXELTI54)\
**Post date:** [January 31, 2023, 8:42pm UTC](https://www.dolibarr.org/forum/t/error-44580-upon-importing-a-date-field/23323/2 "2023-01-31T20:42:20Z")

</div>

**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 “/”)