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
7 - Meteor

Dear Team,

 

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

Please help in getting the formula

 

 

4 REPLIES 4
binuacs
21 - Polaris
vishwa1979
7 - Meteor

Hi,

 

Please check with new file attached

binuacs
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