Home Forums SQL Server 2005 T-SQL (SS2K5) How to find the 2nd Monday following a given date. RE: How to find the 2nd Monday following a given date.

  • How about this?

    set datefirst 1

    declare @basedate as datetime

    set @basedate = '20130808'

    select

    Today = @basedate,

    NextMonday = dateadd(dd, 8-datepart(dw, @basedate), @basedate),

    MondayAfterNext = dateadd(dd, 15-datepart(dw, @basedate), @basedate)

    Happy Coding!!!

    ~~ CK