Importing dates as string does work, but if you’re using slashes (not recommended if you can avoid it) it helps to have that set as your global date format.
The advanced settings are mainly for non-english dates, so you shouldn’t have to use the “strict dates” setting.
But you say it doesn’t work if you use a date like “December 3, 2013” what exactly is happening to the date after it’s imported?
They import properly but do not sort right, either in the front end or the admin.
You can check it out here:
http://spiritual-frontiers.com/wp/events-archive-list-beta/
By properly, you mean the imported record is showing the correct date in the plugin?
Do you have the date fields set as a “date” type on the Manage Database Fields page?
The imported dates are displaying correctly, and I have set my date field to “Date Field” in the “manage database fields” page.
It is just not sorting quite right- it is not sorting alphabetically, but it is not exactly sorting correctly on date either- if you play wit the link I sent, if I sort decending, I have 2001 dates, then 2000 dates, then 2013 dates, etc.
This sorting issue is mainly as a bug report for you to look into. Once I can disable pagination, Datatables will handle the sorting.
Thanks, I appreciate that…very helpful.
Got 1.5.1 and it still is not sorting dates on the back end for me.
I have it working fine on the front-end (Datatables is handling the sorting). But in the admin section, it would be very handy to have date sorting work.
I have a field that I have set as a date field, and my dates are in the form “April 4, 2013”. I am unable to sort by date. If you would like me to send you my csv that I am importing to use as a test case, I’d be happy to.
As mentioned in the other thread, it’s fixed in the next release.
