Converts a text or number representation of a date into a date and time.

See Sigma's Common Date Functions and Use Cases lab for more information about date functions, including use cases and exercises.

Usage

Date(input)

input (required) The input you would like to be interpreted as a date. Input can be a text or number date in ISO format (you should always use DateParse for inputs that aren't in ISO format). When the input is a text value, the best format is "yyyy-mm-dd" or "yyyy-mm-dd hh:mm:ss" (use double quotations for text values). If given a Number, the Date function behaves like DateFromUnix. When using a Number input, you can also perform arithmetic operations in the function.

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 most recent date. Using the Date function allows Greatest to read the input as a date.
Date(1503724894)
  • Returns 2017-08-26 05:21:34

See Also


Was this page helpful?
Yes No