Overview
Syntax | DATE(Year,Month,Day) | Returns a specific date. |
Parameter 1 | Year | Represents the year, which can include one to four digits. |
Parameter 2 | Month | Represents the month. If Month is less than 12, the function uses the parameter value as the month. If Month is greater than 12, the function adds the number of months to the first month in the year specified. |
Parameter 3 | Day | Represents the day. It has the same logic as Month. |
Notes
The extracted data supports three numeric or text parameters.
The real-time data supports three numeric parameters.
Example
Formula | Result | Note |
DATE(1978,9,19) | 1978-09-19 | |
DATE(2000,13,05) | 2001-01-05 | |
DATE(2000,3,35) | 2000-04-04 |
