[Resolved] Wp all export date format .csv

[Author]

Posts

[olivierF]

Hi,

I use the plugin 'wp all export' to export data form CPT in .csv (excell).
When exporting, the format of the custom fields dates are not good (a sequence of numbers) for example '1462147200' instead of MM DD YY.
Do you have a track to solve that?

Thanks.

Olivier

[Minesh]

Hello. Thank you for contacting the Toolset support.

Toolset date field value is stored as Unix Timestamp instead of normal date string. That is why when you export the post content for date field you will see the number for your custom date field value instead of normal date string.

Please check the following links that may help you:
=> https://stackoverflow.com/questions/46130132/converting-unix-time-into-date-time-via-excel

[olivierF]

Thanks but I do not know how is the value stored by Toolset, in seconds or milliseconds? The formula given in the link returns me a date in 1970.

Olivier

[Minesh]

Please check the following links:
=> https://stackoverflow.com/questions/2850624/converting-timestamp-to-unix-time-in-php
=> hidden link
=> hidden link