How do I go back to previous weekday?

[bigspace55]

Hello there! I am trying to take a table with a lot of dates on it and what I want to do is make a query that will give me only the data in the table where the date is between the previous thursday through the previous wednesday. For example, Let's say today is thursday or friday and I want the data for all of the dates between last thursday through this wednesday...what would I type into the date criteria field in order to get this?

[Stingaway]

You can use something similar to:

Between Now()-7 And Now()-2

Just change the numbers a bit to get the exact dates you want.

[bigspace55]

I figured it out...ended up doing this

Between Date()-IIf(Weekday(Date())=1,10,IIf(Weekday(Date())=2,11, IIf(Weekday(Date())=3,12,IIf(Weekday(Date())=4,13, IIf(Weekday(Date())=5,7,IIf(Weekday(Date())=6,8,II f(Weekday(Date())=7,9))))))) And Date()-IIf(Weekday(Date())=1,4,IIf(Weekday(Date())=2,5,II f(Weekday(Date())=3,6,IIf(Weekday(Date())=4,7,IIf( Weekday(Date())=5,1,IIf(Weekday(Date())=6,2,IIf(We ekday(Date())=7,3)))))))