DATETIME
Description
Returns the date and time based on the year, month, day, hour, minute, and second
that you specify.
Syntax
DATETIME(
year
,
month
,
day
,
hour
,
minute
,
second
)
- year: The integer representing the year.
- month: The integer representing the month.
- day: The integer representing the day.
- hour: The integer representing the hour.
- minute: The integer representing the minutes.
- second: The integer representing the seconds.
Example
Formula | Result |
|---|---|
=DATETIME(2016,7,15,8,12,12) | { "7/15/2016 8:12 AM" } |
Notes
- If you specify an argument that is outside the 24-hour clock, or you specify a negative number in an argument, Workday adjusts the resulting time to be valid. Example: =DATETIME(2016,7,15,-44,12,12) returns the value 7/13/2016 4:12 AM.
- If the result is a numeric value instead of a date, check the formatting for the cell to make sure it's set toDate.