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 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 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

Example formula Output
DATETIME(2020, 1, 10, 05, 30, 00) 2020-1-10 05:30:00