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!
Filter or highlight tasks that are ongoing during task calendar exceptions (every other Friday off)
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
Got something working that seems more brute force than elegant, but it gets me there:
Not sure why my posts are doubling up - this was a dup.