Code for pulling records based on "last weeks" date 1

[marie515]

Hi there,

I want to have a query that pulls records based on the "ReceiptDate". I'd like to pull all records received "last week".

How can I tell it to pull all records for the following example:

Today is March 19th.

I'd like last weeks records, so I'd like all records with a receipt date of Sunday, the 7th of March through Saturday, the 13th.

Is there code that says "last week"? I know there is code for last month, next month, and current month and I know how to code for current week, but not how to do a week ago.

I was using the following code, but this is not working:

Between Date() And Date()-7

Any suggestions?

 

[Olaf4]

Hi!
I hope this solve your problem.
In your query add a field: LastWeek: DatePart("ww",[your field Date]), and in the criteria of this field put this: =DatePart("ww",Date())-1.
That’s it.

 

[marie515]

Thank you so much! That worked