Getting the last date of the next month

[Louis]

Hello.

 

I try to get the last date of the next month in my report.  And it's have to work fine even at the end of the year.  By example, if i print my report in december 2019 i want to display on it Jan, 31 2020.

Any suggestion will be very appreciate.

Have nice day everyone.

 

 

[Neli]

Hi Louis,

You need to use the Date and Time Functions: 

- AddMonths to get the first day of the next month;

- AddDays to add the days till the last day of the month;

The expression has to look as follows:

 = AddDays(AddMonths(Fields.Date, 2), - Fields.Date.Day)

You can also check the attached report which demonstrates the approach.

Regards,
Neli
Progress Telerik