title: SSRS Switch Function and date concatenation
body: <p>I have a text field that I'm trying to condtionaly set. I'm new to SSRS and have not sued the Switch Function before. What I'm trying to do is use the function to give me the Month and then concatenate the year - 1 (so last year) to the end of the Month name. I have included the code that is working to give me the month, but I'm not sure how to get the year added to the end.</p>
  
  <p>Thanks for any help.</p>
  
  <pre><code>=Switch(
  Month(Today) = "1", "January",
  Month(Today) = "2", "February",
  Month(Today) = "3", "March",
  Month(Today) = "4", "April",
  Month(Today) = "5", "May",
  Month(Today) = "6", "June",
  Month(Today) = "7", "July",
  Month(Today) = "8", "August",
  Month(Today) = "9", "September",
  Month(Today) = "10", "October",
  Month(Today) = "11", "November",
  Month(Today) = "12", "December"
  )
  </code></pre>