Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Baseline Column Date automatically updates Finish Date

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-05-2011
Member
 
Join Date: Apr 2011
Posts: 5
Baseline Column Date automatically updates Finish Date

Hello
I looking for a solution, whether within MS Project functions or the use of a macro to automatically update the finish column date, if the Baseline date for that column is changed to a date over the Finish date, but still allows you to change the Finish date if needed.

Within my plan I have a Duration, Start, Baseline Finish and Finish columns. What I need is, if the Baseline Finish date for a activity is changed to date after the Finish date, it automatically updates the Finish date to the same as Baseline Date, but still allows you to change the Finish Column date, to date after Baseline Finish date, if the Milestone slips, and a date before Baseline Finish date, if the Milestone has been achieved before Baseline.

Hope that make sense.

Any help would be highly appreciated.

Reply With Quote
  #2  
Old 16-05-2011
Member
 
Join Date: Mar 2010
Posts: 185
Re: Baseline Column Date automatically updates Finish Date

My guess is that he might be confused the "Start" and "Finish" fields as the baseline. Those fields modify at what time you enter Actual. To create a true baseline, you have to project baseline by a Tool for monitoring and Save Baseline. " There are several options in this dialog box, but once created, the baseline start and Finish dates of reference will not change unless someone manually changes or new baselines. Hope this helps in your world.
Reply With Quote
  #3  
Old 16-05-2011
Member
 
Join Date: Apr 2011
Posts: 5
Re: Baseline Column Date automatically updates Finish Date

Many thanks for reply. I thought my thread might be confusing. I totally understand the processes of creating a Baseline and have not confused the "Start" and "Finish" fields as the baseline.

Just say you add a new line on your project. The "Start" and "Finish" columns will have default date and the "Baseline Finish" column will have "NA" until you select a date. What i want is, as soon as i select a date in the "Baseline Finish" column it will update the date in the "Finish" column. So I don’t have to select the same date in the "Finish" column. Usually at the start of a activity the "Baseline Finish" date is the same as the Actual Finish column date. Its only later on where you might realise that we can complete this task before baseline or the task may slip and be completed after baseline, hence the "Finish" column date will change accordingly and "Baseline Finish" will stay the same.
Reply With Quote
  #4  
Old 18-05-2011
Member
 
Join Date: Dec 2006
Posts: 489
Re: Baseline Column Date automatically updates Finish Date

Hi Adam,

Sorry, not possible. The Finish field cannot be manipulated through formulas and if you use a custom field (Finish1 for example), you cannot both have a formula and then be able to modify the data manually.

I'm unclear as to why you are "selecting" dates in the Finish or Baseline Finish field. The Finish is usually calculated based upon Start date+ duration and if you specify a Finish date manually, you are constraining the task with a Finish No Earlier Than constraint. Usually a baseline Finish field is populated by saving a baseline and initially matches the Finish date. The Baseline Finish is not then normally modified except through agreement with all stakeholders.

The Actual Finish will update Finish (it has to) but the baseline finish is not modified and is used to calculate Finish Variance.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Baseline Column Date automatically updates Finish Date"
Thread Thread Starter Forum Replies Last Post
MS Project Incorrect Finish Date Occuring for Non-Standard Calendar B Roberts Windows Software 1 05-08-2010 11:12 AM
MS Project 2007 Current date column shoppingboy Windows Software 3 21-05-2010 12:40 AM
MS Project 2003 Start/Finish Date Issue mehunter48 Windows Software 0 14-09-2009 08:35 PM
Project 2007: Actual Finish Date & Finish Tahseen Shahzad Microsoft Project 3 08-10-2008 04:53 PM
Changing start date and creating formula for finish date stringse Microsoft Project 1 11-09-2006 01:13 PM


All times are GMT +5.5. The time now is 05:14 AM.