Converts a text or date value into an ISO date time.

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



input (required) The input to be returned as a date time. Input can be text or date. If providing a text input, it can represent a date or a date and time; acceptable formats for a text input include "yyyy-mm-dd", "mm/dd/yyyy", or "yyyy-mm-dd hh:mm:ss" (please use double quotes).


  • The above will return the ISO date time 2023-03-07 00:00:00.
DateTime("2023-03-07 15:27:45")
  • The example above returns the ISO date time 2023-03-07 15:27:45.
DateTime([Text Date])
  • The example above returns the corresponding ISO date time for each value in the [Text Date] column.

See Also

Was this page helpful?
Yes No