Convert the value into a date and time. All times are assumed to be UTC.



input (required) The input you would like to be interpreted as a date. Input can be text, number, or date. The given Text value can be a date or a date and time. When inputting a text value for a date, the best format is yyyy-mm-dd hh:mm:ss. If given a Number Date behaves like DateFromUnix.

NOTE: The Date function can be used within other functions to ensure that an input is being read as a date as opposed to text.


Greatest([Invoice Date], Date(“2018-01-01”))
  • Returns the more recent date. Using the Date function allows Greatest to read the input as a date.
  • Returns 2017-08-26 05:21:34

See Also