You are here: Tools > All Tools > Date Time

DateTime Tool

The DateTime tool transforms date/time data to and from a variety of formats, including both expression-friendly and human readable formats.

Alteryx cannot process dates prior to January 1, 1400.

Configuration Properties

  1. Select the format to convert:

    • Date/Time format to string: Converts date/time data in the yyyy-MM-dd format or yyyy-MM-dd hh:mm:ss format to a string.
    • String to Date/Time format: Converts string data to a date/time format in the yyyy-MM-dd format or yyyy-MM-dd hh:mm:ss format.
  2. Select the field to convert. If the data does not include date/time or string data, the text box will display “No Suitable Input Fields Available."
  3. Specify a new column name, or use the default DateTime_Out.
  4. Select the format for the new column (with the Date/Time format to string option) or the format that matches the incoming string field (with the String to Date/Time format option).

Formats

Related Topics Link IconRelated Topics