how to write the current month Dynamically in SSRS

Question

I have Column which has the label "JUL-CurrentMonth Fiscal Year To-Date"

How can i write the expression in which Current month should be populated Dynamically in the label?

I was trying this

"July-" &month(today) " Fiscal Year To-Date"

but it is not working

thanks in advance

Anup Agrawal · Accepted Answer · 2014-05-05T20:45:21.633

0

To get todays date you need to use Now() function.

To get Month use Month function.

"July-" & month(NOW()) & " Fiscal Year To-Date"

To get name of the month use MonthName function.

"July-" & MonthName(NOW()) & " Fiscal Year To-Date"

edited May 05 '14 at 20:45

answered May 05 '14 at 20:37

Anup Agrawal

But the above gives me numerical month but not month name – SqlLearner May 05 '14 at 20:44
Use `MonthName` function. – Anup Agrawal May 05 '14 at 20:44

1 Answers1