DECLARE @MonthNumber int = 10 -- Month Number SELECT DATEADD(dd,(DATEDIFF(dd,0,DATEADD(mm,@MonthNumber-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)))/7 * 7 )+6,0)
Login to post response