SSRS. Specify IF, in expression, to choose month correctly

Vote count:

0

I have expression on Text Box that after StartDate selected It type some text. It working normally, except 1 month of the years is selected It throws an error. I need to specify something like that IF month = 1 then years = -1 month = 12. For now my expression looks like:

= MonthName(Right(Parameters!StartDate.Value-1,2).ToString()) + " - " + Left((Parameters!StartDate.Value - 100).ToString(),4)

And StartDate parameter is in format like: 201401, 201402, 201403, 201404, etc I can't get correct syntax for It.

asked 3 mins ago

Stanislovas Kalašnikovas

43

SSRS. Specify IF, in expression, to choose month correctly