Convert data custom field data to normal date format

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

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

This topic contains 1 reply, has 1 voice.

Last updated by David 4 years, 8 months ago.

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)