This article discusses how to convert Okta Workflows System Dates to epoch time after being exported.
- Workflows
- Open the CSV file in Excel.
- Insert a column next to the system column and provide a name (such as "Date Updated").
- Enter the following formula into the second row of the new column =(A2/86400000)+DATE(1970,1,1), replacing A2 with the first entry for the system column.
- Fill the newly created column so the formula is used for all entries.
- Click the column header in Excel to highlight all rows for the column.
- Change the data type to Date, selecting a short or long date.
The image below shows an example of creating a new column named Human Time for the system.updated column.
NOTE: Custom date columns can be populated via Date cards with an output of Human time, and these will be exported as such. The above relates to the system dates in the tables.
