Filtering Dates

[whatzzup]

Good morning all,
Table below shows dates when activities will begin and end but what if i
want to pickup activities that is due to occur between Mon 15/01/07 and Sat
20/01/07 to show upcomming work during those dates? REMEMBER there is only
the start date 15/01/07 in the table below, hence you cant filter start date
15/01/07 - 20/01/07...will not be picked up. What criterior do you use to
filter in such an instance

Activity A Mon 15/01/07 Sun 04/02/07
Activity B Mon 05/02/07 Sun 11/02/07
Activity C Mon 12/02/07 Tue 13/02/07
Activity D Wed 14/02/07 Wed 14/02/07
Activity E Thu 15/02/07 Mon 19/02/07
Please can someone shed a light, i know in Primavera i would use a logic
statement to say Filter for all Work that begins at "lets say Mon 15/01807 or
Current date or Data date" +4d say.

Thanks in advance

 

[Jan De Messemaeker]

Hi,

The Date range filter will help you
You can make your own filter through Project, Filtered for, More Filters,
New, entering all conditions you can dream of.
HTH

 

[whatzzup]

Thanks but i needs some help in setting up the criterior such as how to tell
it to look for start dates, but all activities to be carried out withing two
dates that in within a predefined start date.

 

[Jan De Messemaeker]

Hi,

First, did you try the Date Range Filter (it's on the filter menu, behind
the "All Tasks" window?
Second, for making your own filter, the start date value is called Start
You will propbably go for two lines
One "is less than or equal"
And
Is higher than or equal

HTH

 

[Trevor Rabey]

You want all Tasks which start, or finish, or are in progress during the
period defined by any two end dates that you nominate.
Finding Tasks with a start and/or a finish date in the period is easy
butTasks can also be in progress during the period if the start is before
the beginning of the period and the finish is after the end of the period.
The criteria you need are:

start >= date1
AND
start <= date2

OR

finish >= date1
AND
finish <= date2

OR

start <= date1
AND
finish >= date2

 

[Jan De Messemaeker]

AFAIK that is what the date range filter does.

 

[Trevor Rabey]

ok

AFAIK that is what the date range filter does.