How do I use the projdateadd function?

[MountainCove]

I would like to create Look-Ahead reports. One for 30, 60, and 90 days based
upon the current Forecast Start Date. This date field would automatically
update as time progresses and be used in conjunction with other criteria [as
a filter] to select only those tasks that qualify. For example, today is
12/14/04 + 30 days = 01/13/05. Then comparing that calculated date to
Forecast Start and if equal to or less than, filter out those tasks for
analysis.

I want to perform this function from preset filter(s) for 30, 60 and 90 day
Look-Ahead Management Reports.

 

[JackD]

You don't need anything fancy.

Paste the following in the formula box for one of the flag fields

IIf([Start]<=[Status Date]+30,True,False)

Then filter on that flag field. True
Do the same thing with different flag fields for 60 and 90 days.

I use status date instead of current date because it is under your control.
You might be preparing this lookahead a few days in advance, or you might
want to look back so it is nice to have control.

It does mean that you need to go to the project menu / project information/
and set a status date, but you should be doing that anyway.

 

[lhankg]

Could someone give me a more detailed instuction on how to get to the flag
field to enter the formula for the 2 week look ahead?

You don't need anything fancy.

Paste the following in the formula box for one of the flag fields

IIf([Start]<=[Status Date]+30,True,False)

Then filter on that flag field. True
Do the same thing with different flag fields for 60 and 90 days.

I use status date instead of current date because it is under your control.
You might be preparing this lookahead a few days in advance, or you might
want to look back so it is nice to have control.

It does mean that you need to go to the project menu / project information/
and set a status date, but you should be doing that anyway.


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

I would like to create Look-Ahead reports. One for 30, 60, and 90 days based
upon the current Forecast Start Date. This date field would automatically
update as time progresses and be used in conjunction with other criteria [as
a filter] to select only those tasks that qualify. For example, today is
12/14/04 + 30 days = 01/13/05. Then comparing that calculated date to
Forecast Start and if equal to or less than, filter out those tasks for
analysis.

I want to perform this function from preset filter(s) for 30, 60 and 90 day
Look-Ahead Management Reports.

 

[Brian K - Project MVP]

Could someone give me a more detailed instuction on how to get to the
flag field to enter the formula for the 2 week look ahead?

You don't need anything fancy.

Paste the following in the formula box for one of the flag fields

IIf([Start]<=[Status Date]+30,True,False)

Then filter on that flag field. True
Do the same thing with different flag fields for 60 and 90 days.

I use status date instead of current date because it is under your
control. You might be preparing this lookahead a few days in
advance, or you might want to look back so it is nice to have
control.

It does mean that you need to go to the project menu / project
information/ and set a status date, but you should be doing that
anyway.


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

I would like to create Look-Ahead reports. One for 30, 60, and
90 days based
upon the current Forecast Start Date. This date field would
automatically update as time progresses and be used in
conjunction with other criteria [as
a filter] to select only those tasks that qualify. For example,
today is 12/14/04 + 30 days = 01/13/05. Then comparing that
calculated date to Forecast Start and if equal to or less than,
filter out those tasks for analysis.

I want to perform this function from preset filter(s) for 30, 60
and 90 day
Look-Ahead Management Reports.

Insert a Flag Field into your view.

Right click on the field header and click on Customize

Then click on Formula button

Enter this formual:

IIf([Start]<=[Status Date]+30,True,False)

This will make it so that tasks that have a start date that is less
than 30 days after the status date will have a True value for this flag
field.

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com