how to get data from last two month to current date

• immaduddinahmed

  Ten Centuries

  Points: 1375

  More actions

  December 8, 2014 at 3:45 am

  #150256

  hi,

  i want a query that retrive last two months data from today date.

  please help me out.

  thanks for the help.

  immad

• Neil Burton

  SSC-Insane

  Points: 23006

  More actions

  December 8, 2014 at 4:10 am

  #1763226

  Have a look at this page[/url] it'll point you in the right direction. We can't do much else without some input from you though. Can you post some sample data please?

  ---

  On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
  —Charles Babbage, Passages from the Life of a Philosopher

  How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

• Emil B

  SSCertifiable

  Points: 5568

  More actions

  December 8, 2014 at 4:12 am

  #1763227

  Combination of this

  http://msdn.microsoft.com/en-us/library/ms188383.aspx

  and this

  http://msdn.microsoft.com/en-us/library/ms186819.aspx

  Should do the trick

• Shiva N

  Hall of Fame

  Points: 3125

  More actions

  December 8, 2014 at 4:15 am

  #1763229

  select * from table where datecol between DATEADD(M,-2,getdate()) and GETDATE()

  Thanks,
  Shiva N
  Database Consultant