Post reply

Date Functions

  • September 10, 2007 at 3:50 am

    #197705

    Hello,

    Ive been using DATEADD on GetDate() so I can bring back a date 10 days after today. Is there a function you can use to bring back a date 10 days previous to todays date. I cant find anything anywhere.

    DATEADD(day,10,GETDATE()) AS DateSent

    Debbie

     

  • September 10, 2007 at 4:00 am

    #732436

    DATEADD(day,-10,GETDATE()) AS DateSent

  • September 10, 2007 at 4:08 am

    #732438

    Of course,

    I cant believe I didnt think of that

    Thanks

    Debbie

     

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

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