I want to skip sundays and i want two dates in amonth

Question

My requirement was i want to to take data for first two days of every month eg(01/08/2016-02/08/2016 I any of this day fall on sunday i want to check next day also that 03/08/2016 I need sql query for that Please do need full o us

Midhun T P · Answer

Hi Please try below query - SELECT CASE WHEN DATENAME(DWDATEADD(dd-(DAY(getdate())-1)getdate()))='Sunday' THEN DATEADD(dd-(DAY(getdate())-2)getdate()) ELSE DATEADD(dd-(DAY(getdate())-1)getdate()) END AS Firstday CASE WHEN DATENAME(DWDATEADD(dd-(DAY(getdate())-2)getdate()))='Monday' THEN DATEADD(dd-(DAY(getdate())-3)getdate()) ELSE CASE WHEN DATENAME(DWDATEADD(dd-(DAY(getdate())-2)getdate()))='Sunday' THEN DATEADD(dd-(DAY(getdate())-3)getdate()) ELSE DATEADD(dd-(DAY(getdate())-2)getdate()) END END AS Secondday

prabhu p · Answer

its working thanks