How to Subtract the Dates in Alteryx

‍

It is very easy to subtract the dates in Alteryx. Here’s a short tutorial on how to do it in simple steps:

1. Inside Alteryx's workflow designer, go to the left-side panel and find 'Formula'. Drag this tool onto the canvas and connect it to the Input Data tool or other sources.
2. Following that, head over to the right-side panel and make all the required configurations. To get started, type a unique name into the Output Column field and then set its Field Type according to your preference.
3. Type 'DateTimeDiff' into the Formula field, then select it from the suggested results.
4. After that, replace DT1 with '[' and select the field containing the End Dates.
5. Subsequently, replace DT2 with the field containing the Start Dates.
6. As for the U, replace it with "Days" or other suitable unit of measure. Make sure that you enclose it inside a pair of quotation marks.
7. Finally, the dates from the selected fields in your Alteryx workflow will be subtracted based on your input.