When exporting user data as described in Exporting User Accounts, you may wish to see the dates in a human-readable format instead of how the data is stored in the database. This can be accomplished by manipulating the data in Excel.
Step-by-step guide
To convert a date field:
After opening your csv file in Excel or LibreOffice, use the following command in a new column. Cell T2 is assumed to be the date cell.
Info Excel or LibreOffice
=(((T2/60)/60/24)+DATE(1970,1,1))
- Next, use Excel'ls autocomplete function to populate the date fields for all rows.
Related articles
Microsoft Excel cell formatting: Format cells
LibreOffice cell formatting: Formatting data