Calculate number of days in Alteryx

[SH_94]

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.

[Emil_Kos · Accepted 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:

[JosephSerpis]

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?

[grazitti_sapna]

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.