how to get start date and end date from week number in stored procedure

C# Corner

sheetal shinde

15y4.5k.NET

how to get start date and end date from week number in stored procedure

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
If this query got resolved then please Accept the post that helped you as Answer.

So other members can easily find the answers.
0

Dorababu Meka15y ago

SET DATEFIRST 4     /* or use any other weird value to test it */
DECLARE @d DATETIME

SET @d = GETDATE()

SELECT
  @d ThatDate,
  DATEADD(dd, (@@DATEFIRST + 5 + DATEPART(dw, @d)) % 7, @d) Monday,
  DATEADD(dd, 6 - (@@DATEFIRST + 5 + DATEPART(dw, @d)) % 7, @d) Sunday