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

More About

Type Functions

Type functions are used to convert an input of one type into other types, e.g. from the string “3” to the number 3. Read more about types of values and how they affect functions.