Compound IIf function 2

[dbero]

I am trying to execute the compound IIf function below. Each of these work fine individually, but when I put in the AND to join the 2, it doesn't work. The logic is if the day of week is Wed,Thur,Fri or Sat, and the 2 dates are in the same week count, then value is "NotbackDated. Should this work?


IIf(DayofWeek="Wednesday" Or DayofWeek="Saturday" Or DayofWeek="Friday" Or DayofWeek="Thursday" And Format([SISSEffectiveDt],"ww")=Format([SUBM Processed Dt],"ww"),"NotBackDated","BackDated") AS Pricing

 

[PHV]

Take care of brackets when mixing OR and AND operators:
IIf([highlight]([/highlight]DayofWeek="Wednesday" Or DayofWeek="Saturday" Or DayofWeek="Friday" Or DayofWeek="Thursday"[highlight])[/highlight] And Format([SISSEffectiveDt],"ww")=Format([SUBM Processed Dt],"ww"),"NotBackDated","BackDated") AS Pricing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cmmrfrds]

Do you mean it doesn't give the expected results? The OR/AND does not match up correctly, I assume.

IIf((DayofWeek="Wednesday" Or DayofWeek="Saturday" Or DayofWeek="Friday" Or DayofWeek="Thursday") And Format([SISSEffectiveDt],"ww")=Format([SUBM Processed Dt],"ww"),"NotBackDated","BackDated") AS Pricing

 

[dbero]

Great Catch!! Missing the ( )was the problem. Thank you!