1 Week Look A Head Schedule

[Catfish Hunter]

I know how to create a look a head schedule where Projects ask you for the
before date. (Start------- Is Less Than or Equal To------- "And before:"?)

Does anyone know how to put a formula in the filter that would automatically
calculate 1 week from the current date and not ask you for a date? This would
give you every task that should be working in the next week.

 

[John]

I know how to create a look a head schedule where Projects ask you for the
before date. (Start------- Is Less Than or Equal To------- "And before:"?)

Does anyone know how to put a formula in the filter that would automatically
calculate 1 week from the current date and not ask you for a date? This would
give you every task that should be working in the next week.

Catfish,
Sorry, formulas can't be put into filter arguments. However, it is
pretty easy to put the formula in a custom field (e.g. Date1) and then
have the filter work on that field.

A similar issue came up a week ago in this newsgroup. You might want to
do a search for "Setting up a dynamic date filter" posted on 12/9/05.

Hope this helps.
John
Project MVP