Description
Returns the serial number of the supplied date.
Syntax
DATE ( year, month, day )
| Parameter | Description |
|---|---|
| year | A 4-digit number between 1900 to 9999. |
| month | A number representing the month (for example,
12 represents December). If a number greater than 12 is supplied, the number is added to the first month of the specified year. |
| day | A number representing the day of the month. If the number you specify for day exceeds the number of days in that month, the number is added to the first day of the specified month. |
Remarks
TIBCO recommends that you always supply a four digit year value. Providing a two digit year may return unexpected results.
If the target field format is datetime, DATE displays the value in mm/dd/yyyy format in the Insight Test Window.
Examples
This function returns 21341:
DATE(1958, 6, 5)
This function returns 41219:
DATE(2012, 11, 6)
See also