1

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

Selected answer as best
Avatar

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.

Avatar

How to change the unixtimestamp format to date and time format ?
Either in WordPress or in Excel.
Thank you so much!

Avatar

@marie – did this help you resolve your problem?

Avatar

Yes! Thank you! šŸ™‚