SQL server reporting services: Expression to show current month name & year

Standard

Here’s a SSRS expressions code that I’ve using lately to show current month name & year in SSRS reports:

[code]

="REPORT NAME"&" – "&MonthName(Month(Today()))&"’"&Year(Today())[/code]

This is a nice little code that you can add to your expressions which will show current name & year. Small little things that you can do to make your business users happy! I hope this helps someone out there.

What do you think? Leave a comment below.