"Rolling date criteria" for Query

[JuJuBe]

I need help with how to write a criteria in a query that only pulls records with a date field that is in the past 6 weeks. I want today and the past 42 days.

 

[alansidman]

Try this:
Between Now() And Now()-42

Alan

 

[JuJuBe]

Thanks Alan. It's not working. I am sure it is due to my ignorance of access.

I am entering this in the criteria box of the field of the query I want to filter in design view. Is that correct? When I run the query after entering this I get zero records. There are lots of records in the table of source data that should match this criteria.

 

[JuJuBe]

I got this to work:

>=DateAdd("d",-45,Date())

 

[alansidman]

Good show