Reference: Supported Date Formats for External Data in Tables and Datasets
External data that you bring into the Data Catalog might contain fields with date or time values. Workday only supports some date formats. How Workday uses the date formats depends on the object you create:
- Table. When you define a Date field in the schema of a table, you can specify any of the supported date formats. The date values in the external data must match the specified date format in order for the row to be valid and loaded into the table.
- Base dataset. If Workday recognizes the format of a date field in the external file, it automatically assigns the Date field type when parsing the file.
If you're new to Workday, you don't have access to create or edit base datasets.
Workday supports these date formats as well as any shortened versions of them:
Format Type | Format |
|---|---|
Date and time | yyyy-MM-dd'T'HH:mm:ss.SSSZZ yyyy-MM-dd'T'HH:mm:ssZZ yyyy-MM-dd'T'HH:mm:ss EEE, dd MMM yyyy HH:mm:ss Z MM/dd/yy h:mm:ss a ZZ MM/dd/yy h:mm:ss a MM/dd/yy H:mm:ss ZZ MM/dd/yy H:mm:ss yy-MM-dd h:mm:ss a ZZ yy-MM-dd h:mm:ss a yy-MM-dd H:mm:ss ZZ yy-MM-dd H:mm:ss yyyy-MM-dd HH:mm:ss.SSS |
Date only | yyyy-MM-ddZZ yy-MM-dd yyyy-MM-dd MM/dd/yy |
Time only | 'T'HH:mm:ssZZ 'T'HH:mm:ss HH:mm:ssZZ HH:mm:ss |