modifying date range

• itortu

  SSCommitted

  Points: 1914

  More actions

  June 27, 2014 at 8:53 am

  #296108

  Hello,

  I would like to ask for help changing the date range to be -1 year from today until today

  This is the current WHERE, AND

  WHERE [entry].[Posting Date] >= DATEADD(YEAR, YEAR(GETDATE()) - 1900, 0)

  AND [entry].[Posting Date] < DATEADD(YEAR, YEAR(GETDATE()) - 1899, 0)

  Thank you so much

• cbrammer1219

  SSCarpal Tunnel

  Points: 4476

  More actions

  June 27, 2014 at 9:19 am

  #1725500

  http://stackoverflow.com/questions/30222/sql-server-get-data-for-only-the-past-year

• itortu

  SSCommitted

  Points: 1914

  More actions

  June 27, 2014 at 10:48 am

  #1725535

  Thank you.