• 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.