Support

Account

Home Forums General Issues Date format Datepicker for CSV Import? Reply To: Date format Datepicker for CSV Import?

  • I hate to drag a two year old topic to the surface, but I’m wondering the same thing? I’m trying to import a large CSV with some dates and am unable to get the dates to show up properly in my Datepicker fields.

    Currently, my dates are formatted in the CSV so j/m/Y, for example: 7/5/2003.

    How should they be formatted in the CSV to be imported properly so ACF can read and display these dates properly?

    Edit
    Ok, that didn’t take too long to figure out. I looked in the database when setting the fields correctly through the ACF form, and saw that the dates were stored like YYYYMMDD or 20030507. Converting the dates in my spreadsheet (Google Drive, via `Format -> Number -> More Formats -> More date and time Formats…) and everything’s working perfectly.