You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
DATE
You can use this function to create a date value out of integers or numbers.
Numbers will be rounded to integers.
There is also a conversion function DATE.
Syntax
DATE ( year , month , day )
Inputs
- year - An integer value between and including 1 and 9999 that represents the year in the constructed date.
- month - An integer value between and including 1 and 12 that represents the month in the constructed date.
- day - An integer value between and including 1 and 31 that represents the day in the constructed date.
Return type
- date
Examples
| Expression | Result | Type |
|---|---|---|
| DATE ( 2010 , 5 , 25 ) | 25-5-2010 | Date |
| DATE ( -2010 , 5 , 25 ) | UNKNOWN | Date |
| DATE ( 2010 , 2 , 29 ) | Error |
Overview
Content Tools