Selecting Activities Between Two Dates

[Jerryinnc]

How do I create a filter where I only select activities that are active
between a start and end date. For example, all activities that are active
between September 1 and September 30, 2005? They may start before September
1 and end after September 30, but they are active for that period of time.

-
Thanks for you help.

 

[John]

How do I create a filter where I only select activities that are active
between a start and end date. For example, all activities that are active
between September 1 and September 30, 2005? They may start before September
1 and end after September 30, but they are active for that period of time.

-
Thanks for you help.

Jerryinnc,
Even though you posted in the developer newsgroup, I doesn't sound like
you are using a VBA routine.

Depending on what you mean by ". . . activities that are active. . .",
the filter could be structured in several ways. If I assume by "active"
you mean tasks that have non-zero percent complete, then the easiest
approach is to modify the existing Date Range filter to include values
for % Complete that are greater than "0". Just "And" the new criteria
with the existing criteria for the dates. Note: you may or may not want
to leave the option for showing related Summary Lines.

Hope this helps.
John
Project MVP

 

[Jan De Messemaeker]

Hi,

Isn't that EXACTLY what the date range filter does?

 

[Jerryinnc]

I am missing something.

The date range filter seems to look at the Start and Finish dates and select
the activities that Start and Finish between the two dates. I am looking for
field names that select the activities that are active between two dates.
For example the Start Date is August 15 and the Finish Date is October 15. I
want to filter the work and % Allocation for the time period of September 1 -
September 30. I then want to look at the resources that have been
overallocated during September by 20% or more. So if the resource was over
allocated in August by 50% and 0% over allocation in Septemebr, then I want
to ignore those activities for that resource.

 

[Jan De Messemaeker]

Have you tried? I did to make sure
Date range does what you want.

 

[Jerryinnc]

Maybe I am making this too complicated.

I first filter on the Tasks to get the period of time that I am interested
in. Say September 1 - December 31, 2005. Then I filtered on Resource with
Peak greater than or equal to 120%. I get some unexplained results.
Majority are correct but some resources have peaks less than 120% for Sept
1-Dec 31.

 

[Jan De Messemaeker]

Hi,

It would have helped a lot if you had explained your problem completely from
the start, not half of it.
This indeed has no standard filter made for it
IMHO the resources with high peaks out of the date range are not eliminated.
Should see the VBA code (this IMHO cannot be done with the custom filters)
to be sure.

HTH