Expression - Last Day of the Month
Hi,
I was wondering if anyone had an expression they should share to calculate last day of the month. Any help is greatly appreciated!
Forum Discussion
6 Replies
We can also use the following expression.
Date.UTC(Date.now().getFullYear(), Date.now().plusDays(1).getMonth(), 0, 0, 0, 0, 0)
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)Thanks, Tim! Learn something new every day.
Alan,
That works great. Thank you
