Post reply

Today - n days

  • August 26, 2008 at 3:47 pm

    #197575

    How do I convert the following from SQL to T-SQL?

    >=Now()-14

    I've looked all over the internet and I can't find anything that I'm sure is working correctly. Thanks!

  • August 26, 2008 at 3:57 pm

    #863440

    gomikem (8/26/2008)

    How do I convert the following from SQL to T-SQL?

    >=Now()-14

    I've looked all over the internet and I can't find anything that I'm sure is working correctly. Thanks!

    >= dateadd(dd, -14, getdate())

    or

    >= getdate() - 14

    😎

  • August 26, 2008 at 4:12 pm

    #863442

    I GOT IT WORKING! THANKS FOR YOUR HELP!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply