SQL Statement to retrieve date from two weeks ago

• tripower

  SSCrazy

  Points: 2035

  More actions

  January 20, 2010 at 8:42 am

  #219725

  I am assuming I would use the dateadd function but how would I retrieve the date from two weeks ago from today's date. I basically need to retrieve records from two weeks ago from whatever is today's date.

• Ray K

  SSC-Dedicated

  Points: 31169

  More actions

  January 20, 2010 at 8:47 am

  #1106097

  roundel1900 (1/20/2010)

  ---

  I am assuming I would use the dateadd function but how would I retrieve the date from two weeks ago from today's date. I basically need to retrieve records from two weeks ago from whatever is today's date.

  Try:select dateadd(ww,-2,getdate())

  Check out BOL for more info on date functions.

  +--------------------------------------------------------------------------------------+
  Check out my blog at https://pianorayk.wordpress.com/

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  January 20, 2010 at 8:55 am

  #1106107

  Two weeks ago including time, or two weeks ago starting from midnight?

  For example,

  Today = 2010-01-20 08:53:07.907

  2 Weeks ago = 2010-01-06 08:53:07.907

  or

  Today = 2010-01-20 08:53:07.907

  2 Weeks ago = 2010-01-06 00:00:00.000