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?
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?