Thursday, July 30, 2020

Find First Sunday of Next Month using EOMONTH is SQL Server

This below query to get First Sunday of Next Month.

DECLARE @tbl_Test_EOMONTH AS TABLE
(
SampleDate DATETIME
)
 
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-12-20')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-11-08')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-10-16')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2015-09-26')
INSERT INTO @tbl_Test_EOMONTH VALUES ('2016-01-31') 


SELECT DATEADD(DAY,8-DATEPART(WEEKDAY,DATEADD(DAY,0,EOMONTH([SampleDate])))
,EOMONTH([SampleDate])) AS FirstSunday_ofTheNextMonth
FROM @tbl_Test_EOMONTH
GO

No comments: