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
SET @CurrentDate = DATEADD(MM, -1, GETDATE())
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.