I am trying to export all user data, and in particular the fields: last login, last update, last active.
But when I open the excel file that was generated, it does not display dates and times for these fields, but series of numbers starting with “16 …..”.
I would like to know the dates of the last activities of my users on my website.
Could you help me please ?
Dates are stored in a format called a unixtimestamp – https://www.unixtimestamp.com/ – these can be converted back into formatted time / date strings using PHP’s date functions http://es2.php.net/manual/en/function.date.php
This plugin does not change the date format, it simply shows you how WordPress has stored the data – but there are filters you can user to manipulate the data exported, should you wish to.
You can find ways to do this inside Excel here: https://stackoverflow.com/questions/16070868/converting-time-stamps-in-excel-to-dates
You need to be logged in to open or reply to Support Tickets.
If you already have an account, please login - if not you will need to register - you can also do this via a Social Network account.