Help with Weekday Function

[Juan4412]

I want to run a query on Monday to show data between Monday and Sunday (of the previous week). I am using this code in my date field, but it is not returning results:

Between Date()-Weekday(Date())+2 And Date()-Weekday(Date())+8

It looks formatted properly to me, any insight would be greatly appreciated.

[Robeen]

In the Criteria of your date field - try something like this:

 
Between Date()-1 And Date()-7

On a Monday, this should give you all dates between the previous Monday & 'yesterday' [Sunday].

Hope this helps!

[Juan4412]

Adding that criteria does not return any results. Even tho, I know there should be data retuarned.

[Robeen]

Any chance you can post your DB [or at least a stripped down version of it] here?
I'm not sure I can help more without looking at what's going on inside.

The criteria I gave you works for me.