Post reply

Future Date

  • December 7, 2009 at 12:12 pm

    #156483

    How would I setup this up? I am not sure of the exact syntax. Any help will be appreciated.

    CUST_ORDER_DESIRED_SHIP_DATE < CURRENT_DATE + 60

  • December 7, 2009 at 12:15 pm

    #1088803

    DATEADD(dd,60,getdate())

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 7, 2009 at 12:49 pm

    #1088836

    Perfect! Thank you!

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

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