Calculated Attribute expressions can be written using the following available functions. Use Cases follow the available functions table.
Note: Date functions require that date values are entered in yyyy- MM- dd or yyyy- MM- dd HH:mm:ss formats. 'ISO Date' and 'ISO Date and Time' validation base type attributes accept only these formats.
|
Date Function |
Parameters |
Description |
|---|---|---|
|
FORMATDATETIME |
(date, format-string[, locale]) |
Determine the output by formatting a date according to the format-string, see documentation for SimpleDateFormat for Oracle on the web. [locale] is optional; see Using a Locale below |
|
LOCALIZEDATE |
(date[, locale]) |
Localize the date to a string using the locale in the current / extracting / resolving context, or using the supplied locale. [locale] is optional; see Using a Locale below |
|
NOW |
() |
Returns current time on server in yyyy-MM-dd HH:mm:ss format. |
To obtain a date or date / time format for a specific locale, in order to override the locale that is specified by the current context, enter the locale's ID and ensure the following property is defined in the sharedconfig.properties file: Calculated.UseLegacyLocalization=true
For more information on locales, see Context Locales documentation in this guide here.
For examples of these functions, see Date Examples here.
2019, Stibo Systems – Confidential