Forum Discussion

GideonAnsell's avatar
GideonAnsell
Qrew Trainee
5 years ago

Run an scheduled automation at bi-weekly frequency

The scheduled automation frequency is limited to once a day, week, month.  I need to trigger a scheduled an automation every other week.  Any ideas about how to do that?

3 Replies

  • You can have a formula field which calculates if the eetl is valid in terms of �every other� and add that as s condition in the steps in the Automation.

    So the automation will run every week, but the individual steps will not fire.

    To calculate if it�s a valid week, you can use the FirstDayOfPeriod function. Post back if you need help with that.
  • Yeah... I'm not following you.  I know how to construct the  FirstDayOfPeriod  formula to test for each 2 weeks, but not sure how you're proposing to use it in the automation.
  • I think I was confused, because it runs on a schedule and not a trigger. Can you tell me the nature of what the Automation does?  If it was just perhaps an import, then the import could be cased to not actually do anything on the off weeks.