Skip to main content
alex_legay
Helper ⭐️⭐️⭐️
July 26, 2016

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

  • July 26, 2016
  • 4 replies
  • 61 views
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
    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
    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
    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