Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter Construction - User Entered Date + N Days

Status
Not open for further replies.

HPROB

Technical User
Nov 7, 2010
2
US
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
 
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
 
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?
 
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top