Function Index

Date

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

Usage

Date(<input>)

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.

Examples

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.
Date(1503724894)
  • Returns 2017-08-26 05:21:34