Homeβ€Ί Dataflows

How to get the second week Tuesday in a month?

user15938
user15938
June 2019 in Dataflows

How to get the second week Tuesday in a month?

0

Comments

  • Cartergan
    Cartergan 🟠
    June 2019

    Try:

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

Categories

  • 10.6K All Categories
  • APAC User Group
  • 12 Welcome
  • 36 Domo News
  • 9.6K Using Domo
  • 1.9K Dataflows
  • 2.4K Card Building
  • 2.2K Ideas Exchange
  • 1.2K Connectors
  • 338 Workbench
  • 250 Domo Best Practices
  • 11 Domo Certification
  • 460 Domo Developer
  • 47 Domo Everywhere
  • 100 Apps
  • 703 New to Domo
  • 84 Dojo
  • 1 Social Groups
  • Domopalooza
  • 1.1K ζ—₯ζœ¬ζ”―ιƒ¨
  • 4 道場-ζ—₯ζœ¬ζ”―ιƒ¨γΈγ‚ˆγ†γ“γ
  • 22 おηŸ₯らせ
  • 62 Kowaza
  • 295 仲間に相談
  • 649 γ²γ‚‰γ‚γε…±ζœ‰