Date for occurrence

[#1]

Algorithm

Hi,
I need to find a solution to calculate when activities occurs. I want to do this in the load script. As example an activity happens on Mondays and Thursdays every 5th week  during 1.5 year.

Thank's 🙂
    

[#2 · Accepted solution]

I figured out the answer when posted question...

In first step:
1) calc no of dayes for the time interval
2) Add a flag if it correct weekday

Second step:

3) A modulus calc if the Flag is correct:
if(Flag=1,if(Mod(Counter,WEEKPER)=0,1,0),0) as Flag