Overview
The date format transform allows you to easily convert datetime strings from one format to another. This often comes in handy when syncing data from one system to another, where each application uses a different format for date and time data.
This transform leverages the Java SimpleDateFormat syntax; more information on this standard can be found in the References section below.
Other Considerations
Transform Structure
The date format transform takes whatever value is provided as the input, parses it based on the inputFormat provided, and then re-formats the datetime into the desired outputFormat:
Example
{
"attributes": {
"inputFormat": "EPOCH_TIME_JAVA",
"outputFormat": "ISO8601"
},
"type": "dateFormat",
"name": "Test Date Format Transform"
}
Attributes
-
Required Attributes
- type - This must always be set to
dateFormat
- name - This is a required attribute for all transforms, and represents the name of the transform as it will appear in the UI's dropdowns
-
Optional Attributes
- requiresPeriodicRefresh - A
true or false value that indicates whether the transform logic should be re-evaluated every evening as part of the identity refresh process.
-
inputFormat - A string value indicating either the explicit SimpleDateFormat or the built-in named format that the data is coming in as
- If no inputFormat is provided, the transform assumes that it is in ISO8601 format
-
outputFormat - A string value indicating either the explicit SimpleDateFormat or the built-in named format that the data should be formatted into
- If no outputFormat is provided, the transform assumes that it is in ISO8601 format
-
input - This is an optional attribute that can explicitly define the input data which will be fed into the transform logic. If input is not provided, the transform will take its input from the source and attribute combination configured via the UI.
Examples
Example 1
Input: 144642632190
Output: 1974-08-02T02:30:32.190-00
{
"attributes": {
"inputFormat": "EPOCH_TIME_JAVA",
"outputFormat": "ISO8601"
},
"type": "dateFormat",
"name": "Test Date Format Transform"
}
This transform will take the incoming Java epoch-based timestamp and format it as an ISO8601 compatible string.
Example 2
Input: 4/1/1975
Output: 1975-04-01
{
"attributes": {
"inputFormat": "M/d/yyyy",
"outputFormat": "yyyy-MM-dd"
},
"type": "dateFormat",
"name": "Test Date Format Transform"
}
This transform will take the incoming date, which is formatted as a common US date string, and format it to match the date structure of most database systems.
References
