Or in an IIF Statement not working

[r0nniem]

this is my code that's not working:

iif(Weekday([answered_time])=1 or 7, "Weekend", IIf(TimeValue([answered_time])<"16:00","Day","Evening")

It will work if I use:
iif(Weekday([answered_time])=1, "Weekend", IIf(TimeValue([answered_time])<"16:00","Day","Evening")
and:
iif(Weekday([answered_time])=7, "Weekend", IIf(TimeValue([answered_time])<"16:00","Day","Evening".

Can you please help?

Thanks in advance

 

[mp9]

iif(Weekday([answered_time])=1 or Weekday([answered_time])=7, "Weekend", IIf(TimeValue([answered_time])<"16:00","Day","Evening")


Or

iif(Weekday([answered_time]) Mod 6 =1, "Weekend", IIf(TimeValue([answered_time])<"16:00","Day","Evening")

http://www22.brinkster.com/accessory/

 

[PHV]

another way:
IIf(Weekday([answered_time]) In (1,7), 'Weekend', IIf(TimeValue([answered_time])<#16:00#,'Day','Evening'))

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