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.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.