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) A socialist is someone who will give you the shirt off *someone else's* back.