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

Question

Suthish Nair · Answer

If this query got resolved then please Accept the post that helped you as Answer . So other members can easily find the answers.

Dorababu Meka · Answer

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