Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate 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
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