Date Query

[KevW]

I am trying to design a query that will bring back records where the date field
in a table is older than 3 months than the current date.

i.e 30/03/2006 is and older than 16/06/2006

Hope this explains it clearly enough

 

[ColinEssex]

You could use this in a query criteria on the date field

 Between [Enter Start Date] and [Enter End Date]

or search for DateSerial - there are many examples posted.

Col

 

[namliam]

Collin, I think he is looking for a more generic solution...

Between Dateadd("M",-3,date()) and date()

 

[crug]

How about

Between DateAdd("m",-3,Now()) And DateAdd("d",0,Now())

 

[namliam]

now would include the time of day, I dont think that is
a) required
b) would make for a viable report...