Filter Construction - User Entered Date + N Days

[HPROB]

I'm trying to construct an interactive filter in MS Project 2007. I'd like the filter to operate like the Date Range filter, but instead of providing a start date and finish date, I'd like to ask the user for a start date and then have the filter select all tasks in a 60 day window from that date. Ideas?

Thanks,
Pat

 

[SkipVought]

This might help...

http://social.answers.microsoft.com/Forums/en-US/addbuz/thread/3978b9a9-aff5-4a1c-95ea-2bf43993b42e

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[HPROB]

Skip,
Thanks for the reply, but I'm not sure that anything in the answers provided in the link helps. Again, I'm trying to filter tasks that start or end in a given 60 day window, but I don't want to use the date range filter in MS Project where one has to enter two dates. I'd like to have the filter ask for a user entered start date and then calculate 60 days out from that date.

Thanks,
Pat

 

[DG17]

The date filter I use all the time (mainly to see where I need to update my plan, check my staff have updated their plans & to provide resources with their deliverables/ tasks in the coming days/ weeks/ months) is the 'should start/finish by' filter, which can be found within the drop down bown on the generic toolbar. Unfortunately it won't calculate the 60 days for you - how important is that for you to do rather than calculating it yourself?

 

[gem1941]

here is one way to do it.
select Date9 (give it name also)
and enter formula [Status Date]

select Date10 (name it)
and enter Formula [Status Date]+40

create a filter and title it "60 Day" (copy the Date Range and modify)

first line Start >= "Start Date:"?
2d line and Finish > [Date9]
3d line and Finish <= [Date10]

if you don't want the summary rows to show, make sure you uncheck "Show related summary rows"

then, in Project Information Set Status Date to whatever date you want to start - say 1 Dec 10

select the filter 60 day
you now have data filtered from 1 Dec - thru appx end of Jan


gem1941