Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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:

  1. 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.

    Excel or LibreOffice

    =(((T2/60)/60/24)+DATE(1970,1,1))

  2. Next, use Excel'ls autocomplete function to populate the date fields for all rows.

Microsoft Excel cell formatting: Format cells

LibreOffice cell formatting:  Formatting data

  • No labels