CODEWITHSUNDEEP
reporting-servicesssrs-2012
Ayesha Khan
Ayesha Khan

Reputation: 125

SSRS: Any UpperCase function in SSRS report

I am trying to display selected month, current month and last month names on my report. I am using 

=Parameters!Month.Label ---> Jun 2016(selected)

=Format(Now(), "MMM") & " " & Format(Now(), "yyyy") ---> Dec 2016 (current) =Format(DateAdd("M", -1, Now()), "MMM") & " " & Format(Now(), "yyyy") ---> Nov 2016 (last)

But I need something like(JUNE 2016, DECEMBER 2016, NOVEMBER 2016 ). Any help would be appreciated. Thank you so much in advance.

Upvotes: 6

Views: 22953

Answers (1)

3N1GM4
3N1GM4

Reputation: 3351

UCase Function

=UCase(Format(Now(), "MMM") & " " & Format(Now(), "yyyy"))

=UCase(Format(DateAdd("M", -1, Now()), "MMM") & " " & Format(Now(), "yyyy"))

Upvotes: 17

Related Questions