DATETIME
Syntax
DATETIME (year, month, day, hour, minute, second, kind)
Description
Creates a DateTime using year, month, day, hour, minute, second, kind. Kind is optional and defaults to unspecified if not set.
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. |
| hour | A number representing the hour of the day. |
| minute | A number representing the minute of the 60 minute hour. |
| second | A number representing the second of the 60 second minute. |
| kind | Indicates whether the time represented by this instance is: - 0=unspecified - 1=UTC - 2=local |
Returns
Returns a DateTime.
Example
The following formula creates a new DateTime that can populate a target field.
DATETIME (2014,11,19,14,15,20,0)
Returns: A DateTime object, which represents November 19, 2014 2:15:20 pm UTC/Local set to unspecified.