Display All records from Now() less 4 weeks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
FieldName Between dateadd("ww",-4,date()) and date()

the dateadd function will return the date -4 weeks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting Dates 2
Crosstab Query - Weekly Days as Header 1
Can't validate dates in Outlook form 8
Filtering by increments of 4 2
display records 30 days and over 1
Stored date is not being recognised 1
Multiple access records to a single word document 2
Calendar control part 2 7

Back
Top