Subtracting Dates

[Guest]

How do I construct a query that shows me all the records that are older than
the current date by 4 weeks?

Thanking you all in anticipation

PMK

 

[Douglas J Steele]

WHERE MyDateField < DateAdd("ww", -4, Date())

 

[Guest]

Use the dateadd function to return the current date + 4 weeks

DateAdd("ww",4,date())