You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
DATE
Converts a value of another data type into a date.
Syntax
DATE(string value, format) DATE(dateTime value)
Inputs
value - The string of dateTime value to be converted to a date type.
format (optional) - The format used for conversion. Format must be enclosed by quotes, e.g. "yyyy-MM-dd". For more info on specifying date format patterns, please see Date and time formats or patterns.
Default formats
When the format is omitted the ISO-8601 date format yyyy-MM-dd (Most to least significant principle) is used for converting the value to a date.
However we advice to use an explicit date format in your conversion function to avoid any confusion about the format used for conversion.
Return type
- date
Examples string to date conversion
- DATE("2024-07-22", "yyyy-MM-dd") converts the string value "2024-07-22" into a value of type date.
- DATE("22/07/2024", "dd/MM/yyyy") converts the string value "22/07/2024" into a value of type date.
Example dateTime to date conversion
- Assume we have a dateTime attribute Person.TimeOfBirth
DATE(Person.TimeOfBirth) will return the date part of this attribute.
Note
The way in which dates are displayed in the UI is determined by the date display formats, which can be configured per language code. For example the Dutch nl-NL date format could be configured as "dd-MM-yyyy", whereas the English en-US date format can be defined as "MM/dd/yyyy".
The converted date in our example could look like "22-07-2024" when displayed in Dutch (nl-NL) and like "07/22/2024" when displayed in English (en-US).
More information about language specific formats can be found in Reference Guide: Language formats.
Overview
Content Tools