Home Forums SQL Server 2005 T-SQL (SS2K5) Previous week date range RE: Previous week date range
ganesaselvam_thylak
Valued Member
Points: 71
More actions
September 1, 2009 at 12:52 am
#1047326
hi Lynn,
Thanks for your query, can u explain the query?
select getdate(), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0), dateadd(wk, datediff(wk, 0, getdate()) - 1, 0) + 4