S
Souris
I have following criteria for my query.
I wanted different date range if it is Friday or not.
IIf(Weekday(Date())=6,Between Day(Date()) And Day(Date()+2),Between
Day(Date()) And Day(Date()+1))
I tested bith criteria are working, but it does not work when I added the iif.
Are there anything wrong when I add iif to specify different date range?
Your help is great appreciated,
I wanted different date range if it is Friday or not.
IIf(Weekday(Date())=6,Between Day(Date()) And Day(Date()+2),Between
Day(Date()) And Day(Date()+1))
I tested bith criteria are working, but it does not work when I added the iif.
Are there anything wrong when I add iif to specify different date range?
Your help is great appreciated,