Convert data custom field data to normal date format

This support ticket is created 4 years, 10 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.

This topic contains 1 reply, has 1 voice.

Author

Posts

March 10, 2020 at 10:36 am #1545487

David

Hi,
We are using a date custom field, which is working fine.

We are exporting our post data to a csv and the date is showing as an timestamp, e.g. 1583107200

I wonder if there is some formula we can run in our CSV (using something like Excel) to convert that number into a date we can understand.

Or if there is some other option to store the date differently in the website's MySql database.

March 10, 2020 at 10:56 am #1545503

David

My issue is resolved now.

I found a formula here: hidden link

essentially:

=(((COLUMN_ID_HERE/60)/60)/24)+DATE(1970,1,1)