Select Page

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



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.


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

See Also


More About Text 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.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.