+13I’m looking for a way to build a Cron expression that would allow a few of my Rules to run every two weeks in order to keep up with my ProServ team’s 2-week cycle. Running it every 15 days with 0 0 12 1/15 * ? unfortunately does not do the trick, and I don’t want to miss adjustments by changing it every month.
Any ideas or suggestions? Any way I can incorporate the Rule Date into the actual Rule logic?
Best answer by jean.nairon
This might be a bigger work around than you would want but you could potentially use a table to track when you want this rule to run. I haven’t tested this out though.
For this trick, you would need to run your rule every Monday. And the key is your data queries will filter for data if the Run Date = Today. So each Monday it will run, but it will only find data that matches every 2 weeks.
First step, I would create a table to host your run dates. Use Excel to create a list of all the dates. You can use a formula in excel to calculate Start Date + 14 day. So in the end you would have,
In your rule, I would add a filter somewhere in your queries to search for the date. If today = run date, then you query provides your expected results. If Today does not equal Run Date, the query would provide zero results, thus your rule would run nothing on the Monday’s where this date does not match.
On your schedule, you would set the rule to run every Monday. When you look at your rule results, you should end up with a run that works on the correct Monday, and then one that fires nothing on the following Monday.
+4“Any way I can incorporate the Rule Date into the actual Rule logic? “
-- In bionic rule’s transformation task you have the rule date available (Formula field → Date fomulas). Is this what you are looking for?
And what all dates are you looking for the rule to run on and why that cron expression won’t work?
+2
+4This might be a bigger work around than you would want but you could potentially use a table to track when you want this rule to run. I haven’t tested this out though.
For this trick, you would need to run your rule every Monday. And the key is your data queries will filter for data if the Run Date = Today. So each Monday it will run, but it will only find data that matches every 2 weeks.
First step, I would create a table to host your run dates. Use Excel to create a list of all the dates. You can use a formula in excel to calculate Start Date + 14 day. So in the end you would have,
In your rule, I would add a filter somewhere in your queries to search for the date. If today = run date, then you query provides your expected results. If Today does not equal Run Date, the query would provide zero results, thus your rule would run nothing on the Monday’s where this date does not match.
On your schedule, you would set the rule to run every Monday. When you look at your rule results, you should end up with a run that works on the correct Monday, and then one that fires nothing on the following Monday.
+13If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
