Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: How to find Week start date and Week end date

    Current Week ==>First day of the week :
    SELECT CONVERT(VARCHAR(10),(DATEADD(DAY,-((DATEPART(DW, (DATEADD(WK, 0, GETDATE()))))-1),((DATEADD(WK,0,GETDATE()))))),120) AS [Current_Week_FirstDay]

    Current Week ==> Last day of the week
    SELECT CONVERT(VARCHAR(10),(DATEADD(DAY,7-((DATEPART(DW, (DATEADD(WK, 0, GETDATE()))))),((DATEADD(WK,0,GETDATE()))))),120)...

Viewing post 1 (of 1 total)