DATETIME

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 numeric field or expression representing the year.
  • month - a numeric field or expression representing the month.
  • day - a numeric field or expression representing the day.
  • hour - a numeric field or expression representing the hour
  • minute - a numeric field or expression representing the minute.
  • second - a numeric field or expression representing the second.

Return data type

Date & Time

Examples

Formula Result
DATETIME(2020, 1, 10, 05, 30, 00) 2020-1-10 05:30:00

Related resources

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue