<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
Okta Workflows System Dates Exported Converted to Epoch Time in CSV
Workflows
Okta Classic Engine
Okta Identity Engine
Overview

This article discusses how to convert Okta Workflows System Dates to epoch time after being exported.

Applies To
  • Workflows
Solution
  1. Open the CSV file in Excel.
  2. Insert a column next to the system column and provide a name (such as "Date Updated").
  3. 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.
  4. Fill the newly created column so the formula is used for all entries.
  5. Click the column header in Excel to highlight all rows for the column.
  6. 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. 

creating a new 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.

Loading
Okta Workflows System Dates Exported Converted to Epoch Time in CSV