iif statement in a query

[gmazza76]

Good Morning,

Sorry for the possibly most straight forward question, but I am trying to create an iff statement ot appear in a column on my Query.
I am trying to work ou if the date in Due Date is lower than todays date I want "Over Due" if it matches todays date "Due" and if its other than these I want it to shop "Open".

I get no errors when using the expression builder, but it doesnt show on the query even though I do have the Show ticked

WStatusIIf («expr», IIf([Due Date]<Date(), “Over Due”, IIf([Due Date]=Date(),”Today”, “Open”))

Thanks in advance

 

[Joe4]

Try this:

Expr: IIF([Due Date] < Date(),"Over Due",IIF([Due Date]=Date(),"Due","Open"))

<date(),"over due",iif([due="" date]="Date(),"Due","Open"))[/CODE]</html"></date(),"over>