Sunday 3 March 2019

Get Start and end date of the next week in sql server

////////////////// Sql script

declare @SelectdData varchar(10)='2019-03-04'


SELECT DATEADD(d,(9- DATEPART(dw,@SelectdData)),@SelectdData) StartDateOfWeek, DATEADD(d,6,(DATEADD(d,(9- DATEPART(dw,@SelectdData)),@SelectdData)))EndDataOfWeek



///////////////////Result


No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...