Home Forums SQL Server 2008 SQL Server 2008 - General Query to find the start day of the week as Monday RE: Query to find the start day of the week as Monday

  • December 4, 2012 at 9:23 am

    #1565391

    Thanks for the reply.

    I used the below case statement in my Select statement to get the starting day as Monday:

    (CASE WHEN datename(dw,date) <> 'Sunday' THEN CONVERT(varchar(10), DATEADD(WK, DATEDIFF(WK, 0, date), 0),

    103) ELSE CONVERT(varchar(10), DATEADD(WK, DATEDIFF(WK, 0, date), - 7), 103) END)

    Thanks all!