This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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()
Hi @Jay09 ,
You will need to use the DateTimeDiff(dt1,dt2,u) function from the date time formula section.
Hope this helps.
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