datetime() Function

Function

datetime( year, month, day, hour, minute, second )

Converts the given Date and Time into a serial number that holds the Date and Time data type.

Parameters

Returns

Date and Time

Usage considerations

The value is converted to GMT when stored.

Examples

1
datetime(2011, 2, 28, 12, 0, 0)

Returns 2/28/2011 12:00 PM GMT+00:00.

1
datetime(2009, 7, { 5 }, 7, 1, 20)

Returns 7/5/2009 7:01 AM GMT+00:00.

1
2
3
4
5
6
7
8
datetime(
  { 2009, 2008 },
  { 7, 4 },
  { 5, 10 },
  { 12, 10 },
  { 2, 20 },
  { 0, 0 }
)

Returns {7/5/2009 12:02 PM GMT+00:00, 4/10/2008 10:20 AM GMT+00:00}. All lists must be the same length.

1
datetime(2009, 7, 9, {}, 2, 0)

Returns {}. A value must be passed for all arguments in order to receive a valid output.

Out-of-range time values

Each of the time parameters has a normal range of values. You can use positive or negative values outside the normal range for any of these parameters.

Positive out-of-range values

1
datetime(2022, 10, 9, 26, 63, 61, 1002)

Returns 10/9/2022 3:04 AM GMT+00:00.

Negative out-of-range values

1
datetime(2022, 10, 9, 12, -60, 0)

Returns 10/9/2022 11:00 AM GMT+00:00.

1
datetime(2022, 10, 9, -25, 0, 0)

Returns 10/9/2022 11:00 PM GMT+00:00.

Dictionaries and maps

1
datetime(2022, 10, 9, {hours: 10}.hours, 0, 0)

Returns 10/9/2022 10:00 AM GMT+00:00.

1
datetime(2022, 10, 9, a!map(hours: 10).hours, 0, 0)

Returns 10/9/2022 10:00 AM GMT+00:00.

Append a time to a date

1
2
3
4
5
6
7
8
9
10
11
a!localVariables(
  local!date: date(2022, 10, 24),
  datetime(
    year(local!date),
    month(local!date),
    day(local!date),
    23,
    59,
    00
  )
)

Returns 10/24/2022 11:59 PM GMT+00:00 by adding the time 11:59 PM to the date given in local!date.

See also

• date(): Limitations on year also apply to Date and Time. Dates that return null in date() will throw an error when used in datetime().
• userdatetime(): Use this function to return a Datetime value in the local time zone.

Feature compatibility

Feedback