Dates of last user activity
Hello everyone,
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 ?
Thanks
How to change the unixtimestamp format to date and time format ?
Either in WordPress or in Excel.
Thank you so much!
You can find ways to do this inside Excel here: https://stackoverflow.com/questions/16070868/converting-time-stamps-in-excel-to-dates
@marie – did this help you resolve your problem?
Yes! Thank you! 🙂
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.
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.