Tuesday, October 26, 2010

Get week date range from date


Query 






SELECT

CONVERT(varchar(50), (DATEADD(DD, @@DATEFIRST - DATEPART(DW, GETDATE()) - 6, GETDATE())), 106) as [First Date]
,CONVERT(varchar(50), (DATEADD(DD, @@DATEFIRST - DATEPART(DW, GETDATE()), GETDATE())), 106) as [Last Date]

 Screen Shot

 


No comments:

Post a Comment