Can we use alteryx to calculate number of days of shown below :
The results below i use excel to calculate it and wondering if Alteryx able to deduct the days for us based on two different date.
Solved! Go to Solution.
Hi @SH_94,
The formula for this should look like this:
DateTimeDiff([Date End],[Date Begin],'days')
Just remember that you need to have data in date format. I have prepared workflow for you:
Output:
Hi @SH_94 the function DateTimeDiff is what you need to use the syntax DateTimeDiff([A],[B],"days") will produce the results you expect. I mocked up a workflow to showcase this, let me know what you think?
Hi @SH_94,
This is my take on this problem. I hope it helps.
If it solves your purpose, please mark it as a solution.