Convert data custom field data to normal date format

This support ticket is created vor 5 Jahren, 2 Monaten. 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.

Dieses Thema enthält 1 Antwort, hat 1 Stimme.

Author

Artikel

März 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.

März 10, 2020 at 10:56 am #1545503

David

My issue is resolved now.

I found a formula here: versteckter Link

essentially:

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