Grass (2/28/2013)
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())
END
This 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
How are you using the variable @CurrentDate? It would help to see the actual query involved.