Using todays date in an IF statement

[MHS]

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

[atcodedog05 · Accepted solution]

Hi @MHS 

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

Hope this helps : )

[MHS]

Thank you!

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