Home Forums SQL Server 2008 SQL Server 2008 - General SQL query 4 weeks 3 business days RE: SQL query 4 weeks 3 business days

  • March 11, 2013 at 5:09 pm

    #1595784

    David Mando (3/11/2013)

    Thanks so much for your quick response.

    How would I write this query if it is just (- 4 weeks and 3 days)?

    select dateadd(day, -3, dateadd(week,-4,getdate()));

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".