Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the date represented by year, month, and day formatted according to the short date style in the system's Regional Settings. The values for year, month, and day reflect the Gregorian calendar.
Syntax
DATE(year, month, day)
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| year |
Required |
Integer |
The year. |
| month |
Required |
Integer |
The month. |
| day |
Required |
Integer |
The day. |
Example 1
DATE(1999,6,7)
Returns the value representing 6/7/1999.
Example 2
DATE(1999,6,7) + 4 ed.
Returns the value representing 6/11/1999.
Example 3
FORMAT(DATE(1999,10,14),"C")
Returns the value representing Tuesday, October 14, 1999.