How can I get the last day of a month?

Question

I have a date and need to know the last day of that month

Answer 1

Here is a function you can use to get the last day of the month:

function getLastDayOfMonth(stringDate) {
   var date = qie.deduceDate(stringDate);
   var cal = java.util.GregorianCalendar.getInstance();
   cal.setTime(date);
   return cal.getActualMaximum(java.util.Calendar.DAY_OF_MONTH);
}

Here is an example of how to call it:

qie.debug('2/20/2017: ' + getLastDayOfMonth('2/20/2017'));

Answer 2

If you want to get the last day of the month on a source node using CRON you can use:

0 0 0 L * *