Date
The Date function converts text and number values to ISO date time format.
Text and number values must already reflect ISO format to correctly convert the output. For values reflecting non-ISO formats, use the DateParse function.
Syntax
Date(value)
Function argument:
- value (required) - the column that contains values to convert to ISO date time format.
When converting text, input values must be formatted as "yyyy-mm-dd" or "yyyy-mm-dd
hh:mm:ss". Note the double quotes.
When converting an integer, the Date function behaves like DateFromUnix. You can also use numerical input to perform arithmetic operations in the function, such as adding, subtracting, multiplying, and dividing.
The Date function can be used within other functions to ensure that a value is read as date, not as text.
Examples
Date(1503724894)
- Returns
2017-08-26 05:21:34
Greatest([Invoice Date], Date(“2018-01-01”))
- Evaluates all values in the Invoice Date column against January 1, 2018 and returns the most recent date. In this example, Date with a
"2018-01-01"value argument allows the Greatest function to read the input as a date.