Home Forums SQL Server 2005 T-SQL (SS2K5) Previous week date range RE: Previous week date range
Lynn Pettis
SSC Guru
Points: 442467
More actions
March 11, 2009 at 11:56 am
#957761
Check out the following code and see if it does what you need:
select getdate(), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0) + 4