Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
DATETIME

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 to
    Date
     .

This content is not part of the Workday Administrator Guide.