Date format for imports

This thread is resolved. Here is a description of the problem and solution.

Problem:

Import custom date fields using CSV file.

Solution:

The custom date field of Types plugin stores value in timestamp format, so you will need to convert the date value into timestamp format too.

Relevant Documentation:

This support ticket is created 5 years, 5 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: Setting up custom fields, Types plugin

This topic contains 2 replies, has 2 voices.

Last updated by Bob 5 years, 5 months ago.

Assisted by: Luo Yang.

Author

Posts

June 26, 2019 at 8:26 pm #1277911

Bob

I'm having difficulty getting a date set using WP All Import. Every format I enter in the CSV to be imported results in "January 1, 1970". This would be great if every date I would ever need would be in the seventies.

I found this post: https://toolset.com/forums/topic/import-date-field-from-the-events-calendar-plugin/
But all the links are hidden links, so there's not much to be learned from those...

So please tell me, how do I get dates imported into custom fields?

June 27, 2019 at 2:01 am #1278015

Luo Yang

Hello,

The custom date field of Types plugin stores value in timestamp format, so you will need to convert the date value into timestamp format too. for example, with Excel tool:
hidden link

July 1, 2019 at 8:30 am #1280697

Bob

That did the trick 🙂 Thanks!