Home Forums Article Discussions Article Discussions by Author Discuss content posted by Seth Phelabaum Date Manipulation with DATEADD/DATEDIFF RE: Date Manipulation with DATEADD/DATEDIFF

  • April 7, 2010 at 9:34 am

    #1147457

    SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 2) will produce today's date not Start of the day 2 days from now as you stated.

    Good idea to have scripts for dates