Converting strings to dates and dates to strings

There are a variety of date formats that need to be updated to a data type that meets the needs of the analysis. A string formatted date may need to be updated to a date/time format. On the other hand, a date/time format may need to be updated to a string format. The complexity of updating this can be quite cumbersome and there are formulas available to make these necessary updates. Better yet, there is a DateTime tool in Alteryx that includes options on selecting the format to convert.

The following image shows the DateTime tool located in the Parse tool palette.

The DateTime tool can convert ...

Get Learning Alteryx now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.