Need Last Weeks Info Query

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

Guest

How can I pull the information for the previous week? The week will run Monday through Sunday. Example: On 10/22/03 I want to run a query that will pull information from the week of 10/13/03 to 10/19/03. I have a field in a table that has the date of denial and I want to pull the accounts that have a denial date within that particular week. I know how to do this if I run the query on a given day, what I dont' know is how to do it if I run it on a different day (without having to change the parameters in the query every time.

TIA,

John
 
Your criteria against the DenialDate field should be something like the following.

BETWEEN DateAdd("d",-(6+WeekDay(Date(),2)),Date())
And DateAdd("d",-WeekDay(Date(),2),Date())
 
Back
Top