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

[Tjillett]

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

[Tjillett]

Thank You.. Works like a charm

[JohnJPS]

Sounds great.  Another tip to keep in mind is the IIF statement... the syntax is IIF(Condition , Value When True , Value When False )  ... this could be used to shrink your inner IF considerably:

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

... or even both IF's, though it becomes less read-able then:

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

 Happy blending!