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:
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!