Is there a way to compare dates from week to week?

We link several smaller schedules to a master schedule and I would lik
to compare the dates on the master schedule from one week to another t
see which dates have changed. The functional leads keep slipping date
without informing anyone and I want to find the tasks that have th
"finish" dates moved out without having to manually scour through tw
schedules

--
cherylinc
-----------------------------------------------------------------------
cherylincr's Profile: http://forums.techarena.in/member.php?userid=4941
View this thread: http://forums.techarena.in/showthread.php?t=96903

http://forums.techarena.i

Rod
Thu May 15 19:03:22 CDT 2008

Hi,

In the master schedule, save the baseline each week before project updates
are done. The Tracking Gantt Chart view will then show date changes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



"cherylincr" <cherylincr.39h5vg@DoNotSpam.com> wrote in message
news:cherylincr.39h5vg@DoNotSpam.com...
>
> We link several smaller schedules to a master schedule and I would like
> to compare the dates on the master schedule from one week to another to
> see which dates have changed. The functional leads keep slipping dates
> without informing anyone and I want to find the tasks that have the
> "finish" dates moved out without having to manually scour through two
> schedules.
>
>
> --
> cherylincr
> ------------------------------------------------------------------------
> cherylincr's Profile: http://forums.techarena.in/member.php?userid=49413
> View this thread: http://forums.techarena.in/showthread.php?t=969036
>
> http://forums.techarena.in
>

Dytham
Fri May 16 02:27:03 CDT 2008

Or, as you may wish to preserve your main Baseline data, save an interim
baseline each week, eg. to Start10, Finish 10.

You can then use spare Text fields to contain a formula which calculates the
difference, in number of working days, between current dates and those in the
weekly baseline. eg:

IIf(Finish10<>ProjDateValue("NA"),ProjDateDiff([Finish10],[Finish])/480,"NA")

The If statement here avoids the value showing as an error for any tasks
added during the week.

"cherylincr" wrote:

>
> We link several smaller schedules to a master schedule and I would like
> to compare the dates on the master schedule from one week to another to
> see which dates have changed. The functional leads keep slipping dates
> without informing anyone and I want to find the tasks that have the
> "finish" dates moved out without having to manually scour through two
> schedules.
>
>
> --
> cherylincr
> ------------------------------------------------------------------------
> cherylincr's Profile: http://forums.techarena.in/member.php?userid=49413
> View this thread: http://forums.techarena.in/showthread.php?t=969036
>
> http://forums.techarena.in
>
>