Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Using todays date in an IF statement

MHS
8 - Asteroid

Hello Alteryx Community!

 

I have run into a situation where I need to use todays date in an IF statement to substitute for a change timestamp that is missing from the data.  The scenarios are a time difference calculation using two change timestamps for the first and a time difference calculation using one change timestamp and todays date for the second.  I am using the "Datetimetoday()" function in place of one of the timestamps and am unable to produce any results from the statement.  I believe that I have most of the statement structured correctly with the exception of the second condition which I am sure needs to be tweaked.  I appreciate all the help and let me know if you have any questions.

 

Thanks, 

 

Matt

 

MHS_0-1648233348960.png

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @MHS 

 

You need to add status value in the 2nd condition. Please take a look into it.

 

atcodedog05_0-1648233757699.png

 

Hope this helps : )

 

MHS
8 - Asteroid

Thank you!

 

I knew it was something simple that I was not seeing...

Labels
Top Solution Authors