Expression Help

[Laura987]

Hello,

I need help with an expression. I'm trying to get this:

If Order date plus 21 days does not equal ship date and shipping detail is none then mark it Regular Ship

IIf(([ORDER DT]+21)<>[SHIP DATE]) & IIf([SHIP DETAIL]="None","Regular Ship"))

 

[James Dudden]

Try this:
IIf(([ORDER DT]+21)<>[SHIP DATE]) AND [SHIP DETAIL]="None","Regular Ship","")