Scheduling events on the X week of the month

[BubbaDuck]

Help me think through this problem... I can think of bad and onerous ways to do this. The goal is to set a scene for say the week before Memorial Day. Memorial Day is the last Monday of May. Th ebst I have thought of is awful IF statements

If May and Monday and Date Between 26 and 31

Then I would have to do similar for each day preceding Memorial Day. Is there a driver or better way to to this that I haven't considered? FWIW, the Chowmain Holiday driver is dead.

[mujtaba.khokhar]

There’s a driver on driver central , called schedule it!

 

It links in with google calendar, I’m sure google shows when the holidays are you can get it to execute an event that way.

 

Thanks

Muj

 

 

Sent from my iPhone using Tapatalk

[RAV]

For there to be 5 mondays in May, then the 3rd monday has to be less than 22.

Two events need to trigger on the Monday before Memorial Day.

Scheduler event: Third Monday in May, repeat annually
      If day of month > 21, stop {cause that means Memorial day is on the fifth Monday in May}
     else do whatever, set variable early to true {Memorial day will be the fourth Monday in May}

Scheduler event: Fourth Monday in May, repeat annually
     if early is true, set to false and stop {already did the week early thing}
     else do whatever {because it's now a week before Memorial Day}

 

[BubbaDuck]

32 minutes ago, mujtaba.khokhar said:

There’s a driver on driver central , called schedule it!

 

It links in with google calendar, I’m sure google shows when the holidays are you can get it to execute an event that way.

 

Thanks

Muj

 

 

Sent from my iPhone using Tapatalk

Ah, that’s perfect!

 

RAV is describing where I was headed and that’s painful.