cancel
Showing results for 
Search instead for 
Did you mean: 

Expression - Last Day of the Month

aaronb
New Contributor

Hi,

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

6 REPLIES 6

aleung
Contributor III

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
New Contributor

Alan,

That works great. Thank you

tstack
Former Employee

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
Contributor III

Thanks, Tim! Learn something new every day.