Setuping up Weekly Query

[Trilback]

I have a forum that I need a weekly query. I have a daily one but I want to be able to run a report based on a query of what I inputed for the week. My week is Mon - Fri. I think I do now() + 5 right? I tried that but it did not show me all from today this is past week monday aka the bigging of this week.

 

[maw230]

Need more info. Maybe you can post your original query.

 

[Trilback]

Sorry been busy at work. I think I need the datepart fuction is my query. I have a cdate field in my table. I want it so that when I run the query it shows my execptions for that week starting with monday. Dunno if thats more helpful.

 

[namliam]

well if you want to find out "What was last monday" thats pretty easy...

Date() - weekday(date(),2) + 1

and then if you want "the next friday", yes that is +5

 

[Trilback]

well if you want to find out "What was last monday" thats pretty easy...

Date() - weekday(date(),2) + 1

and then if you want "the next friday", yes that is +5

but I would I set the criteria in the query with that info? I tried (date() -5) but that did not work like I wanted it to.