We have a client that wants to open an hour early every other Wednesday. We tried the iCal Recurrence Rule in the Admin Scheduling section. The system accepted our formula (FREQ=WEEKLY;INTERVAL=2;BYDAY=WE) and let it save, but it didn't route correctly.
In the scheduling section there is a part where you specify the date you want it to start and end and the time you want it to start and end. So, we entered August 15, 2018 at 8 am to December 31, 2018 at 9 am. Instead of the system looking at the custom expression of every other Wednesday in the iCal Recurrence Rule box it's just looking at the date and time. In essence the schedule is open from 8 am on August 15th, to 9 am on December 31st.
So, is there something wrong with this formula or can we create an expression in Architect itself to do the job?
The UI is admittedly a bit confusing and we are working on a clearer way to let you set such schedules.
The end date is used for the end of the first occurrence. So if you set start as August 15th and end as December 31st then I would expect that the first occurrence would last this long. If you are trying to say "first occurrence is August 15th and repeat this every other Wednesday until Dec 31st" then you would use UNTIL to specify December 31st and the end date would be 9am on August 15th.
It'd be similar to how you'd create an Outlook meeting invite - first you have to say how long the meeting is and on what day and then next specify the date after which the meeting should no longer repeat.
This will return true for even weeks. Check for == 1 if you want the odd weeks.
Also you will need to update your flow at the end of 2020--there are 53 weeks that year so you will need to switch from even to odd or vice versa.
I'm going to file the "WeekNum(GetCurrentDateTimeUtc()) % 2 == 0" expression away just in case, but now that I understand the iCal Recurrence it's working. Plus, I would probably forget to change the architect expression in 2020.
