Date Difference in Alteryx.

[rohit782192]

Hello Team,

How can we calculate the difference of the date in Alteryx.

[RolandSchubert · Accepted solution]

Hi @rohit782192 ,

there is a function DATETIMEDIFF to calculate the difference between two dates.

DateTimeDiff([Field1],[Field2],'days')

where 'days' can be replaced by the unit you need (e.g. 'month').

Best,

Roland

[rohit782192]

I Tried it is working for me.

[okaychill]

I tried it is giving null for some values not sure why though