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

Hi,

Please try below query -

SELECT CASE WHEN DATENAME(DW,DATEADD(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(DW,DATEADD(dd,-(DAY(getdate())-2),getdate()))='Monday'

THEN DATEADD(dd,-(DAY(getdate())-3),getdate()) ELSE

CASE WHEN DATENAME(DW,DATEADD(dd,-(DAY(getdate())-2),getdate()))='Sunday'

THEN DATEADD(dd,-(DAY(getdate())-3),getdate()) ELSE

DATEADD(dd,-(DAY(getdate())-2),getdate()) END END AS Secondday