Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
funkkube
Starting Member
8 Posts |
 Posted - 2004-09-30 : 11:20:07
|
| HiI am trying to qrite a query to get records of a date range by clicking on a "this week" "next week" "two weeks time" buttons and was wondering the best way to do it! For example if today is Thursday and I clicked this week it would bring up records from Monday to Friday of this week.Thanks in advance!mat |
|
|
funkkube
Starting Member
8 Posts |
Posted - 2004-09-30 : 11:27:43
|
| ok had a brain wave..I could use WEEK OF THE YEAR..Work out what WOTY this week is and then pull off records.Next week would by WOTY +1 etc etc..Can I do this in a query?thanks |
 |
|
|
Ledell
SQL NASCAR Parsing Chick
107 Posts |
Posted - 2004-10-05 : 13:25:14
|
| I would think it would be better to set up a module that computes that and call the module from the button properties.*************************Got some code from Rob. Can anyone help? |
|
|
|
|
|
|
MS Access query to get "this weeks" "next weeks"