Return current month string.

[Michael]

I am trying to get the month returned in a string in a report parameter. I currently have

Now().Month

But I suspect it is returning the number of the month because the field is blank when I run the report, which is strange because the other report parameter is

Now().Year

and that works just fine. I tried formatting as a string, but that did not work either. What am I doing wrong?

[Plamen Mitrev]

Hello Michael,

The Now() function actually returns a DateTime object and you can adjust the end result in the Report Designer according to the documentation. By default, the expression "Now().Month" returns the current month on this machine as a number from 1 to 12. You can choose the format of the returned month and convert it to string at the same time with the sample expressions below.

= Now().ToString("MMMM") //returns the full month name
= Now().ToString("MMM") //returns the shortened month name up to 3 characters

Please try the above suggestions and configure the expression for your requirements. Let me know if you need further assistance.

Regards,
Plamen Mitrev
Progress Telerik

[Michael]

Thank you, this is exactly what I needed, I was missing ToString.

[Plamen Mitrev]

I am happy to hear that you can now get the exact output that you need!