How can I schedule a rule to run every 2 weeks on a particular day?

[Nick Menere]

When scheduling a rule, I can set an interval every 14 days but I can't set the day I want it to execute.

If I use a Cron expression to schedule, you can't specify every 2 weeks (every fortnight).

Is there a way to run the rule every 2 weeks on a Monday at 9am?

[Nick Menere · Accepted solution]

In order to do this, you will need to use Cron to run the rule every Monday at 9am and then use a condition to check that it is an even (or odd) week of the year.

Your trigger would like:

You condition (the first thing after the trigger) will look like:

What this is doing is:

• Rendering the current week of the year
• Finding the remainder when you divide it by 2
• If this is 0, it must be an even week, otherwise it is an odd week.

The formulae is:

{{#=}}{{#now}}w{{/}} % 2{{/}}

[oren.david]

@Nick Menere it didn't work to me, however this comparison works fine:

It checks if the week number is even.

{{#=}}{{now.weekOfYear}}/2 - ROUND({{now.weekOfYear}}/2,0){{/}}

[Diego Quesada]

Hi It doesn't work for me. Can ypu help me

[oren.david]

@Diego Quesada the simple way to validate math expressions is to print them in a comment. For this I recommend to create a rule for tests (that you execute manually or something like that) and add an action to add comment to the issue.

Put the expression above in the comment and run the rule and see the results.

The week number today is even (week #32), so the result should be zero.

If you need more help please share printscreen.

[Diego Quesada]

Will be like this?

[oren.david]

yes, now run the rule manually in an issue and see the results.