Skip to main content

Date Format

Overview​

Use the date format transform to convert datetime strings from one format to another. This is often useful when you are 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; see the References section for more information on this standard.

Other Considerations
  • In addition to explicit SimpleDateFormat syntax, the date format transform also recognizes several built-in "named" constructs:
    • ISO8601: This is the date format corresponding to the ISO8601 standard. The exact format is expressed as "yyyy-MM-dd'T'HH:mm:ss.SSSZ".
    • LDAP: This is the date format corresponding to the LDAP date format standard, also expressed as "yyyyMMddHHmmss.Z".
    • PEOPLE_SOFT: This is the date format format used by People Soft, also expressed as "MM/dd/yyyy".
    • EPOCH_TIME_JAVA: This represents the incoming date value as the elapsed time in milliseconds from midnight, January 1st, 1970.
    • EPOCH_TIME_WIN32: This represents the incoming date value as the elapsed time in 100-nanosecond intervals from midnight, January 1st, 1601.

Transform structure​

The date format transform takes whatever value provided as the input, parses the datetime based on the inputFormat provided, and then reformats it into the desired outputFormat.

{
  "attributes": {
    "inputFormat": "EPOCH_TIME_JAVA",
    "outputFormat": "ISO8601"
  },
  "type": "dateFormat",
  "name": "Date Format Transform"
}

Top-level properties (required)​

  • type string (required)
    Must be set to dateFormat.

  • name string (required)
    The name of the transform as it will appear in the UI's dropdown menus.

  • requiresPeriodicRefresh boolean (optional)
    Whether the transform logic should be reevaluated every evening as part of the identity refresh process. Default is false.

Attributes​

The date format transform uses the following structure:

{
  "type": "dateFormat",
  "name": "Transform Name",
  "attributes": {
    "inputFormat": "ISO8601",
    "outputFormat": "yyyy-MM-dd"
  }
}

attributes (optional)​

The attributes object contains the date format configuration.

Optional​

  • inputFormat string (optional)
    The format of the incoming date. Either a SimpleDateFormat pattern or a built-in named format (ISO8601, LDAP, PEOPLE_SOFT, EPOCH_TIME_JAVA, EPOCH_TIME_WIN32). Default is ISO8601.

  • outputFormat string (optional)
    The desired output format. Either a SimpleDateFormat pattern or a built-in named format. Default is ISO8601.

  • input object (optional)
    Explicitly defines the input data passed into the transform. If not provided, the transform uses input from the source and attribute combination configured in the UI.

Important This transform does not currently support the "now" keyword as an input value. :::

Examples​

This transform takes the incoming Java epoch-based timestamp and formats it as an ISO8601 compatible string.

Input: 144642632190
Output: 1974-08-02T02:30:32.190-00

Transform request body:

{
  "attributes": {
    "inputFormat": "EPOCH_TIME_JAVA",
    "outputFormat": "ISO8601"
  },
  "type": "dateFormat",
  "name": "Date Format Transform"
}

 

This transform takes the incoming date, formatted as a common US date string, and formats it to match the date structure of most database systems.

Input: 4/1/1975
Output: 1975-04-01

Transform request body:

{
  "attributes": {
    "inputFormat": "M/d/yyyy",
    "outputFormat": "yyyy-MM-dd"
  },
  "type": "dateFormat",
  "name": "Date Format Transform"
}

References​