Query - Use of date()

[gbc123]

Hi,

I am trying to evaluate data in a field called "JOBDATE" from my table.

I have a query where basically I want the select results to be as follows :

If Today e.g date() is Monday then results to be between date()-3 and date()-1
else
date()-1

If I use (as criteria in a grouped select query (using where..)) this >>

iif(weekday(date())=2,date()-3) it works .. as soon as it becomes
iif(weekday(date())=2,>=date()-3) it gives no records, also
iif(weekday(date())=2,between date()-3 and date()-1,date()-1) is what I expected would work.

Your wisdom is appreciated.

Thanks.

Gary™

 

[Cbrine]

Check out the online help for the DateDiff() Method. This should give you the results you are looking for.

Cal