[Question | Telerik Standalone Report Designer]: How to show previous month date in text field parameter?

[Austin]

Good Afternoon Telerik,

 

I run a report for the previous month at the beginning of every month. In example, Today's Month is April- I run the report for the entire Month of March. How can I create a Text field within Telerik that will show the previous month in example March and updates every month so if I run it May 1st it'll show April etc..?

 

I've tried the following functions but kept getting an error. (see screenshot)

= Today(AddMonths() -1)

 

 

 

[Dimitar]

Hello Austin,

The problem with the expression is that the AddMonths(date, months) function should wrap the Today() date and not the other way around.

For example:

= AddMonths(Today(),-1)

I tested this expression locally and was able to get last month's data this way, please test it on your end too, and let me know if that helps.

Regards,
Dimitar
Progress Telerik

[Austin]

That worked great, Thank you!!!