It is very easy to subtract the dates in Alteryx. Here’s a short tutorial on how to do it in simple steps:
- 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.
- 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.
- Type 'DateTimeDiff' into the Formula field, then select it from the suggested results.
- After that, replace DT1 with '[' and select the field containing the End Dates.
- Subsequently, replace DT2 with the field containing the Start Dates.
- 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.
- Finally, the dates from the selected fields in your Alteryx workflow will be subtracted based on your input.
