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]

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.

[aaronb]

Thanks Tim for the additional info!

[Anil]

We can also use the following expression.

Date.UTC(Date.now().getFullYear(), Date.now().plusDays(1).getMonth(), 0, 0, 0, 0, 0)