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