IF / ELSEIF condition2 THEN true2 ELSE false ENDIF - Error with datetimenow

Have a little bit of a roadblock on one last piece. I relatively new to Alterxy and tried searching for an answer before posting.

Here's my error any help would be appreciated.

I have my no/ no working but believe there is an error in my Else IF. I need to have an output that shows datetimenow minus order date if greater than 3.

What am I missing...Thanks

IF [New Conf Date]='NO' THEN 'NO'
ELSEIF DateTimeNow() - [Order Date]>3 THEN 'Inprocess'
ELSE 'Maybe'
ENDIF

Error Message

Date Time

Accepted answers

JohnJPS

According to the IF statement, rows having [NewConfDate]='NO' will evaluate to 'NO' ... and that will happen regardless of the order date, which is in the "else" portion of the statement...

For things unexpectedly showing as 'Inprocess'... you could generate a new column using the Formula tool with:

DateTimeDiff(DateTimeNow(),[Order Date],"days")

... just in order to see what the values are, which is helpful for debugging... if (for instance) they're all negative numbers, then just reverse the order of the dates:

DateTimeDiff([Order Date],DateTimeNow(),"days")

Hope that helps!

JohnJPS

Oops, typos, and missed the first "THEN" ...

IF DateTimeDiff(DateTimeNow(),[Need Date2],"days") > 0 THEN
   IF IsNull([Confirm-Date]) THEN 
      'YES'
   ELSE
      'NO'
   ENDIF
ELSE 
   'N/A'
ENDIF

All comments

JohnJPS

You will probably want to use DateTimeDiff(DateTimeNow(),[Order Date],"days") > 3 rather than just using a minus sign. Can you try that and see how it goes?

Tjillett

Getting closer, Thank you - Updated

Issue is that order date vs today is some that are greater than 3 days reporting 'NO'

No 'Inprocess' being reported when data has plently of 3 days and less

IF [New Conf Date] ='NO' THEN 'NO'
ELSEIF DateTimeDiff(DateTimeNow(),[Order Date],"days") >3 THEN 'Maybe'
ELSE 'Inprocess'
ENDIF

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703