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 (for ecample, "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 with the formula so it is applied to all entries.
- Click the column header in Excel to highlight all rows for the column.
- Change the data type to Date and select a short or long date format.
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.
