Need Last Weeks Info Query

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
 
J

John Spencer (MVP)

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())
 

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

Extract data from previous week, previous two weeks, etc. 2
Return multiple records from a single entry. 2
Query records with single Dates Automatically 9
Add a field to Query 2
Daily breakdown per week 11
How do I get just the weekday out of a long date 3
Crosstab Queries by week 2
Need Sum of Weeks Between 2 Dates 1

Top