Creates a date with time.
Sample usage
DATETIME(Year, Month, Day, Hour, Minute, Second)
Syntax
DATETIME(year, month, day, hour, minute, second)
Parameters
year
- a Number field or expression representing the year.month
- a Number field or expression representing the month.day
- a Number field or expression representing the day.hour
- a numeric field or expression representing the hourminute
- a numeric field or expression representing the minute.second
- a numeric field or expression representing the second.
Return data type
Date & Time
Examples
Example formula | Output |
---|---|
DATETIME(2020, 1, 10, 05, 30, 00) |
2020-1-10 05:30:00 |