Calculate number of days

[Mzaheer24]

Hello Everyone,

I used to calculate number of days in MS excel using formula =TODAY()-date

Please advise how i can calculate days in Alteryx 

[DataNath · Accepted solution]

Hey @Mzaheer24, you'll want to use the DateTimeDiff() function in a Formula tool:

DateTimeDiff(DateTimeToday(),[Date],'day')

[Mzaheer24]

How I can make bucket like - 0-10 days,11-30 days and 30+ days