Expression - Last Day of the Month

[aaronb]

Hi,

I was wondering if anyone had an expression they should share to calculate last day of the month. Any help is greatly appreciated!

[aleung]

Here is an example of last day of this month. You can revise it to fit your needs.

Date.parse(Date.now().plusMonths(1).getFullYear()+“-”+Date.now().plusMonths(1).getMonth()+“-”+“01”).minusDays(1)

[aaronb]

Alan,

That works great. Thank you

[tstack]

aleung:

Here is an example of last day of this month. You can revise it to fit your needs.

Date.parse(Date.now().plusMonths(1).getFullYear()+“-”+Date.now().plusMonths(1).getMonth()+“-”+“01”).minusDays(1)

Note that you can avoid the string manipulation and use the withDayOfMonth() method to replace the current day with 1, like so:

Date.now().plusMonths(1).withDayOfMonth(1).minusDays(1)

[aleung]

Thanks, Tim! Learn something new every day.