Next 3 Months

[MikeC]

I have a report on which I need to display the names of the next 3 months. For example, if the report is run in March I need to display April in field 1, May in field 2 and June in field 3. If the report is run in July I'd need to display August in field 1, September in field 2 and October in field 3.

What expressions will work to return the next 1, 2 and 3 months names?

Thank you.

[Alex K.]

Hello,

You can use the following expression:

Code: Select all

{(DataTimeVariable.AddMonths(1)).ToString("MMMM")}

Please see sample report in attachment.

Thank you.