Error with importing data for Date fields

Support
1

I am trying to import a CSV file that includes a DOB field in the format dd/mm/yyyy. I get an error saying ‘System Error : Error 1292: Incorrect date value’. Any idea what I am doing wrong?

2

Hi Leonore,

To import your CSV file with your DOB field, you will need to format the date to be:
yyyy-mm-dd

Once you do this, you should have no problem importing your CSV file.