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 |
|
wafw1971
Yak Posting Veteran
75 Posts |
 Posted - 2013-02-28 : 11:35:10
|
| I have @From date SET as 07/01/2013 which is a Monday I need to change the @From to represent 13/01/2013 instead without changing the SET date.SET 07/01/2013SELECT DATEPART(weekday,@From) = At the moment the result is Monday (2) 07/01/2013 I need it to be Sunday (1) 13/01/2013.I hope this made sense.ThanksWayne |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-28 : 11:57:01
|
| Instead of using @From in places where you use it, use DATEADD(dd,6,@From). |
 |
|
|
|
|
|
@From date query