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
