Filter or highlight tasks that are ongoing during task calendar exceptions (every other Friday off)

P
Pat O 👤 Member for 12 years

Hi.  I have an MSP task calendar that reflects that those working to that calendar have every other Friday off.



I would like to create a filter that will highlight which tasks are affected by these Fridays.  This seems to be defined as "what tasks have a start date before the off-Fridays and end after the off-Fridays".  This calendar causes work on the task to stop on end of day Thursday and resume on Monday.



If it helps and is not on a bad or inefficient track, I have been able to identify tasks that Start on the off-Fridays by picking one and calculating each 2 weeks forward with this flag:



(Fix([Start])-DateValue("5/9/14")) Mod 14=0



I have been unable to figure out so far how to identify those tasks that are ongoing across an off-Friday.  Any help is greatly appreciated.  Thanks!

P
Pat O 👤 Member for 12 years

Got something working that seems more brute force than elegant, but it gets me there:

  1. Find the first and second Fridays following the start of a task. 
  2. Test to see which of those Fridays is an off Friday.
  3. Test to see if the task is not yet finished by the off Friday.
  4. Also flag tasks starting the Monday after an off Friday.
P
Pat O 👤 Member for 12 years

Not sure why my posts are doubling up - this was a dup.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts