How to get the second week Tuesday in a month?

How to get the second week Tuesday in a month?

Comments

  • Cartergan
    Cartergan Contributor

    Try:

      SELECT DATEADD(DAY, (DATEDIFF(DAY, 3,  
    DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)) / 7) * 7 + 14, 1)