Skip to main content

Schedule a rule to run on the last day of the month

  • July 26, 2016
  • 4 replies
  • 37 views

alex_legay
Forum|alt.badge.img+7
I think it would be good to be able to run a rule on the last day of the month. I know it is possible to set it to run on the last Friday or any other weekday of the month but this is not what is needed here.

Is there any reason why we cannot schedule a rule to run on the last day of the month?

4 replies

sundar
  • Expert ⭐️
  • July 27, 2016
Thanks for posting this idea. Added this to backlog.

zach_davis
Forum|alt.badge.img+4
  • Helper ⭐️
  • April 11, 2017
I just ran into this as well. My question though is how does the system handle if you select for the rule to run every month on the 31st? What will it do in months that do not have 31 days?

Edit:

I just tested this and it skips that month. I ran a historical rule that is setup to run on the 31st of every month. It ran for January 31 and March 31. 

kate_green
Forum|alt.badge.img
  • Helper ⭐️⭐️
  • May 18, 2018
Hi Alex - I just came across your posting - not sure if you've solved this yet. But you can do this with advanced scheduling, using a cron expression such as:

0 0 6 L 3/3 ?

This runs a rule that runs at 6am, on the Last day of the 3rd month of each quarter. 

prabhat
Forum|alt.badge.img
  • Contributor ⭐️⭐️
  • September 12, 2018
Here is the cron expression to run the rule on last day of  every month 

Expression : 0 0 0 L * ? *

Example:
  • Fri, Nov 30, 2018 01:00 am 
  • Mon, Dec 31, 2018 01:00 am
  • Thu, Jan 31, 2019 01:00 am
  • Thu, Feb 28, 2019 01:00 am
  • Sun, Mar 31, 2019 00:00 am