Software

Ask something
Question Locked

MS Project creating a dynamic Date Filter

0 helpful
3 replies

by costantiniwm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi all, Im trying to create a filter for MS Project 2003, that will fliter out and show only my milestone tasks. Also I want it to be dynamic, so I want to tell it to take today (current date/time) and look back 2 weeks for the start, and go ahead 2 weeks from now as the last start date. Ideally it displays a snap shot of 1 month. Any and all help is appreciated. Thanks, WMC

3 replies

by ccantafio71

Right click on one of the column headings in Project, and select "Customize Fields".
Select Typ: Date in the Dialog box.
Pick one of the available date fields and rename it to "2 Weeks Back". Under the Custom Attributes select formula and enter something like [Current Date]-14.
Do the same for a field named "2 weeks out". Formula will be [Current Date]+14.

Create a custom filter:
Select Project -> Filtered for: XXXXX -> More Filters.
Select New.
Select And in the And/Or; Milestone in the Field Name column; equals in the Test column; and yes in the Values column.

Go down to the next line and select: And/Or = And; Field Name = Start; Test = greater than or equal to; Value(s) = {insert your customized date field here}

Repeat for the end date as well (2 weeks out).

Hit OK to exit the dialog box, and select your new filter and hit Apply.

You should be good to go.
Hope this helps.

by stct

I am trying to define a custom filter with following parameters in Resource Usage view:

1. Display on Not Completed tasks (%Work Complete <> 100%)
2. Start < Today + 15 days OR Basline Start < Today + 15 days.

Unfortunately, this showed me tasks with Start and Baseline start date 3 months out..

Any advise?

Thank you in advance,

This discussion is closed to new replies.