Display All records from Now() less 4 weeks?

P

PMK

How do I construct a query to display only those records that are 4 weeks or
older than todays date. I should specify that "today's date" is the day that
the query is run.

I have tried Now () - 30 <= [daterequired] (daterequired is the name of
the field in question)

Thanking you all in anticipation.

PMK
 
O

Ofer

FieldName Between dateadd("ww",-4,date()) and date()

the dateadd function will return the date -4 weeks
 
Top