Subtracting Dates

PMK · Jun 16, 2005

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 · Jun 16, 2005

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

Ofer · Jun 16, 2005

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

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