Problem with Toolset dates

Problem with Toolset dates

I have been having lots of problems with importing date fields.
This process illustrates my difficulty.

I have a ‘testdates’ CSV file:
ID Date in text Date as excel shortdate UNIX
1 11th November 1968 11/11/1968 -35942400
2 25th December 2002 25/12/2002 1040774400
3 29th January 2002 29/01/2002 1012262400
4 2nd August 2017 02/08/2017 1501632000
5 3rd October 1974 03/10/1974 149990400

I make a custom post type called ‘testdates’

I make a new field group for this post type:

I add a test entry.

I do an import of my CSV file using WPAllimport.

I make a view for these records:

 

The unixdate field works fine on the front end view….. but in the Admin view the unix column fails:

Sorted one way:

Sorted the other way:

Comments are closed.