The Data School - Alteryx: DateTime Summary

The DateTime tool (see below) in Alteryx is used to transform datetime data to and from a variety of formats.

In order to make use of this tool, it is important to note the following data type formatting:

Date: yyyy-MM-dd
Time: hh:mm:ss
Datetime: yyyy-MM-dd hh:mm:ss

Now that you know this, it's time to look at an example using this tool:

Note: Converting the field *Date* from datetime format to string format

You'll need to specify the format for the new column DateTime_Out, or create a custom format. Some are obvious, but others - not so much. Therefore, to ensure that you get the correct output, I have created the following summary:

In this very basic example, the selected format is dd/MM/yy hh:mm:ss.

Hope this helps!