Convert data custom field data to normal date format

This support ticket is created Il y a 5 années et 2 mois. 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.

Ce sujet contient 1 réponse, a 1 voix.

Auteur

Publications

mars 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.

mars 10, 2020 at 10:56 am #1545503

David

My issue is resolved now.

I found a formula here: lien caché

essentially:

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