Other than scripting, is there any other way to check the date retrieved from the record is the current month end date?
How creative do you want to be in avoiding scripting?
You could set 2 properties in a map, 'currentWeek' and 'nextWeek', with the "W" date format(Week in month). 'currentWeek' would be the date of interest and 'nextWeek' would be date+1.If 'nextWeek' == 1 and 'currentWeek' != 'nextWeek', then you would know it is the month end date....or just use something like java.util.Calendar.getActualMaximum()
Retrieving data ...