Find the first date, last date and total days of a month
Posted by: Neel Aakash on: November 16, 2011
DECLARE @Date datetime SET @Date = '2011/11/16' SELECTÂ DATEADD(dd,-(DATEPART(dw, @Date) - 1),@Date) AS 'First day of the week', DATEADD(dd,-(DATEPART(dw, @Date) - 7),@Date) AS 'Last day of the week', DAY(DATEADD(d, -DAY(DATEADD(m,1,@Date)),DATEADD(m,1,@Date))) AS 'Total day of the month'
Advertisement
