You are here: Reference > Date Time Functions

Date/Time Functions

Use date/time functions in the expression editor to create, manipulate, and format date and time values.

Alteryx uses the ISO format yyyy-mm-dd HH:MM:SS to represent dates and times. If a date/time value is not in this format, Alteryx reads it as a string. To convert a column for use and manipulation in the date/time format, use the DateTimeParse function in the expression editor or the DateTime Tool.

The date/time functions report conversion errors if they are given bad input, if a date does not match the expected format, or if a date is invalid.

Types of date/time functions

Format strings

Date/Time format strings are used by the DateTimeParse and DateTimeFormat functions to tell Alteryx how to parse (read) or format (write) date/time values. Format strings are comprised of specifiers and separators.