derby leeds blog

Here is the T-SQL code to get the Week Start Date and Week End Date.

SELECT GETDATE() AS [Today], DATEADD(WK, DATEDIFF(WK, 0, GETDATE()-1), 0) AS [Week Start Date], DATEADD(WK, DATEDIFF(WK, 0, GETDATE()-1)+1, -1) AS [Week End Date]