InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 00:41:09 GMT20http://www.sqlservercentral.com/Forums/Topic1425290-1292-1.aspxWithout seeing the code we can't give you the answers you want. It is a black box and all we can do is shoot in the dark.Fri, 01 Mar 2013 06:51:35 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1425290-1292-1.aspxI tried DATEADD(mm,0,Getdate()) also and the current month but didn't get the previous month. Need previous months and current together.Thu, 28 Feb 2013 22:46:11 GMTGrasshttp://www.sqlservercentral.com/Forums/Topic1425290-1292-1.aspxI'll take a shot in the dark. You're setting the current date to last month. Try setting it to this month. DATEADD(mm,0,getdate())Thu, 28 Feb 2013 15:30:14 GMTErin Ramsayhttp://www.sqlservercentral.com/Forums/Topic1425290-1292-1.aspxCan't see from here what you see there. There really isn't enough information to help you unless all you want are shots in the dark.Thu, 28 Feb 2013 15:23:56 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1425290-1292-1.aspx@CurrentDate in the procedure is as a parameter and Set to NULL. So in the SSRS report the user will not enter the date. Only input the other information and the report should pull the data for past months including the current month as well. So far if I use the logic mentioned above works to return up to Jan month. ThanksThu, 28 Feb 2013 15:21:46 GMTGrasshttp://www.sqlservercentral.com/Forums/Topic1425290-1292-1.aspx[quote][b]Grass (2/28/2013)[/b][hr]Hi all,Trying to get data by month for current month and previous month in ssrs but couldn't able to get it. I was using this statement in procedure:IF @CurrentDate IS NULL BEGIN SET @CurrentDate = DATEADD(MM, -1, GETDATE())ENDThis gives me records up to Jan and not for Feb month. I want also Feb month in there. How should I write this. Hope this makes sense.Thanks[/quote]How are you using the variable @CurrentDate? It would help to see the actual query involved.Thu, 28 Feb 2013 14:54:51 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1425290-1292-1.aspxHi all,Trying to get data by month for current month and previous month in ssrs but couldn't able to get it. I was using this statement in procedure:IF @CurrentDate IS NULL BEGIN SET @CurrentDate = DATEADD(MM, -1, GETDATE())ENDThis gives me records up to Jan and not for Feb month. I want also Feb month in there. How should I write this. Hope this makes sense.ThanksThu, 28 Feb 2013 14:52:30 GMTGrass