FORMAT_DATE

The FORMAT_DATE function is used to format a date time value.

Usable: Value Fields

Syntax: { FORMAT_DATE(( PARAM_1 PARAM_2 PARAM_3 )) }

Parameter	Type	Examples	Description
PARAM_1	JSONPath	`$.value`	The JSONPath expression representing the date and time that should be formatted
PARAM_2	string	`'d'`, `'D'`, `'f`', `'F'`, `'g'`, `'G'`, `'m'`, `'o'`, `'r'`, `'s'`, `'t'`, `'T'`, `'u'`, `'U'`, `'Y'`	The format specifier.
PARAM_3	string	`'en-US'`, '`de-DE'`, '`es-ES'`, '`fr-FR'`, etc.	The culture.

Value Field Example

For example, consider the following data source JSON:

CODE

{
  "value": "2020-09-01T22:05:45.488+02:00"
}

Use the FORMAT_DATE function to format the value to a date string

CODE

{ FORMAT_DATE(( $.value 'g' 'de-DE' )) }

This will result in 01.09.2020 20:05

Format and Culture Examples