CODEWITHSUNDEEP
c#reporting-servicesssrs-2012
URVIL SHAH
URVIL SHAH

Reputation: 51

Keeping the month fix And Year varied in reporting service

I am using SSRS 2012 and I have searched on internet about the problem I am experiencing a small problem , In the header I want the following Date format.

So from Current Month + 5 years till the Fiscal Year.

e.g. If I run this month it should display Dec 2015 (Current Month) through June(Fiscal Year ending, always will be ending in June ) 2020 (Five Years from the Current year) . What should be expression in Textbox For SSRS P.S - I am rendering Report into PDF

Upvotes: 0

Views: 44

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10860

This should work the way you want with any date:

=FORMAT(TODAY, "MMM yyyy") & " through " & FORMAT(TODAY.AddYears(5).AddMonths(6 - MONTH(TODAY())), "MMM yyyy")

You can replace TODAY with a field if you need to.

Upvotes: 1

Related Questions