Conversion function DATE

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 no format is specified, the ISO-8601 date format (yyyy-MM-dd) is used for converting values to dates, following the principle from most to least significant.
We recommend specifying an explicit date format in your conversion function to ensure clarity and avoid confusion.
The system default time zone (local time) is applied when converting the dateTime string. Converting time between different time zones involves various factors, such as daylight saving time and regional differences, which can be complex. Currently, Blueriq does not have built-in functions for performing these time zone calculations, so we recommend using a custom service for accurate time zone 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.

Back to Top