I'm using VB datd Reports to create Reports & have given the user an option to choose from the following three:

1) Daily Reports
When the user chooses this option, I save it to the registry and when the program is being closed it looks for the option that is selected and if this is the chosen one...then the report is generated.

2) Weekly Reports in this My sql query will change to something like this: "Select * from Table1 where Date > today < 7days...how do I write this query? And lets say user chooses weekly reports today...and till today he was having Daily reports...how do I count number of days...pls suggest ways...

In other words I'm asking, if a user switches to Weekly reports, do I start counting days from today...or shall I start counting from every Monday....and please help me doing this. I have no clue how to count days...