In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help in formula

vishwa1979
8 - Asteroid

Dear Team,

 

I am not able to find days difference between two dates in Altreyx.

Please help in getting the formula

 

 

4 REPLIES 4
binu_acs
21 - Polaris
vishwa1979
8 - Asteroid

Hi,

 

Please check with new file attached

binu_acs
21 - Polaris

@vishwa1979 If your date fiels are not in the ISO format(yyyy-mm-dd) you need to use the DateTimeParse() function to convert it into to Alteryx Date type then apply any datefunctions

image.png

grazitti_sapna
17 - Castor

Hi @vishwa1979 
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks 

Sapna Gupta
Labels
Top Solution Authors