Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Subtracting dates

Jay09
6 - Meteoroid

Hi,

 

I am trying to subtract requirement date - today in alteryx. But it shows invalid type in subtraction (Please refer the attached workings and let me know the best solution to rectify).

 

Ex : 06/24/2016 - Today()

 

thanks

Jay

3 REPLIES 3
LukeM
Alteryx
Alteryx

Hi @Jay09 ,

 

You will need to use the DateTimeDiff(dt1,dt2,u) function from the date time formula section.

 

Hope this helps.

 

Luke

 

 

sumitiiest
8 - Asteroid

Hi @Jay09 ,

 

Please Find attached your workflow with the formula to calculate the difference between two dates.

I have used the DateTimeDiff function to get the days difference

 

 

days count.PNG

 

Thanks,

Sumit

ywang7
7 - Meteor

 

 

Labels