We can not be scheduled the email alert set on the last day of every month. NS only provides set a specific day of the month( Because the number of days in each month differs, recurring monthly events cannot be scheduled after the 28th), So we have to add one more criteria in the saved search.
- Add the search criteria for only to run the search on the last day of the month
ie, Formula(Numeric) | Case When Last_Day{today}={today} Then 1 Else 0 End | Criteria to be ‘greater than 0′
In this criteria search result only shows the last day of the month. - Set the search schedule to process daily at the desired time.
- make sure to not select the option to send emails if are no result.