Get Current Month and Current Year


  • Hi

    I have created an srs report in report builder 3.0
    At the top of my report, I need to add the current month and year (example:  July, 2013)

    I added a textbox and tried using an expression to get the current month which gave me 7
    using the datepart function however I need to get "July" instead.

    Also I was not able to add an ", " + 2013 on the end.

    Can someone please help me with this?

    Monday, July 22, 2013 10:45 PM


  • Hi ,

    Try the below expression in your textbox :

    =MonthName(Month(FormatDateTime(Today(),DateFormat.ShortDate))) & "," & Year(FormatDateTime(Today(),DateFormat.ShortDate))

    sathya --------- Mark as answered if my post solved your problem and Vote as helpful if my post was useful.

    Wednesday, July 24, 2013 5:36 PM

All replies