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)
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 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.