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 |
|
miked1978
Starting Member
25 Posts |
 Posted - 2009-07-16 : 14:07:54
|
| My table has 7 weeks worth of data and I have a date field in my table, named Mondate which is the Monday of every week. I have a query that is set to run on Wednesday of every week and I always need it to get the previous weeks mondate. For example if I ran the query yesterday (Wednesday the 15th) I want the data from (7/6) and not 7/13/09. Can anyone help? |
|
|
|
|
|
Getting the previous weeks date