DATE
Syntax
DATE (year, month, day)
Description
Creates a date with the default time of 12:00 am.
Arguments
| year | A number representing the year. |
| month | A number representing the month of the year. |
| day | A number representing the day of the month. |
Returns
Returns a DateTime.
Example
The following formula creates a new date that can populate a target field.
DATE (2014,11,19)
Returns: A DateTime object that represents November 19, 2014 12:00 am.