How to get the second week Tuesday in a month?

user15938
user15938
in Magic ETL

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)

Categories