CODEWITHSUNDEEP
datereporting-servicesparameters
grahamie
grahamie

Reputation: 311

Previous month in parameter

I need to set a Hidden Default Parameter in SSRS.

In my query I need to not show last months total but the month before that, ie in Feb I need to show Dec totals.

I usually use this for last month but cannot tweak it for the month prior.

Set first date of last month:

=DateAdd("m", -1, DateSerial(Year(Now()), Month(Now()), 1))

Set last date of last month:

=DateAdd("d", -1, DateSerial(Year(Now()), Month(Now()), 1))

Upvotes: 3

Views: 11613

Answers (2)

Silagy
Silagy

Reputation: 3083

If i understand you right you want to:

Get the first day of two months from now

=DateAdd("m", -2, DateSerial(Year(Now()), Month(Now()), 1))

And you want to get the last day on month two months from now

=DateAdd("d" , -1 , DateAdd("m", -1, DateSerial(Year(Now()), Month(Now()), 1)))

Upvotes: 5

Ian Preston
Ian Preston

Reputation: 39566

Depending on exactly what you need, use something like:

DateAdd
(
    DateInterval.Month
    , -1
    , DateAdd(DateInterval.Day, -1, DateSerial(Year(Parameters!Date.Value), Month(Parameters!Date.Value), 1))
)

Used in a report:

enter image description here

Upvotes: 0

Related Questions