Current date data problem in SSRS

Question

Current date data problem in SSRS

Grass

Ten Centuries

Points: 1149
More actions
February 28, 2013 at 2:52 pm

#290458

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

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.

Grass Ten Centuries Points: 1149 More actions · Answer 2

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

Thanks

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Can'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.

Erin Ramsay SSCrazy Eights Points: 9728 More actions · Answer 4

I'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())

Grass Ten Centuries Points: 1149 More actions · Answer 5

I tried DATEADD(mm,0,Getdate()) also and the current month but didn't get the previous month. Need previous months and current together.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

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