none
How to disconnect two Date columns in Microsoft Project 2010 RRS feed

  • Question

  • Hi,

    I have a question about Microsoft Project 2010. I have a project that has two Date columns - "Due" and "Actual Finish" columns. For a task, at the planning phase, I will only have "Due" date. When the task is done, I change the "Actual Finish" date for that task from "NA" to an actual date. However, when I do that, the "Due" date is changed too and it's changed to be the same as the "Actual Finish" date. What I want is the "Due" date doesn't change with the "Actual Finish" date.

    How can I get that work?

    Your help is deeply appreciated!

    Thanks,

    Yifan

    Friday, February 22, 2013 5:46 PM

Answers

  • Yifan --
     
    The Due column to which you refer is actually the Finish column.  Apparently you or some previous PM changed the Title for the column to show Due instead of Finish.  You can float your mouse pointer over the Due column to confirm what I am saying.
     
    What you are seeing in Project 2010 is the default behavior of the tool.  Prior to progress being entered on the task, the Finish date is the planned finish date for the task.  When you enter actuals for a task, Project 2010 ALWAYS replaces planned values with actual values.  This means that the Start date is changed to the Actual Start date, the Finish date is changed to the Actual Finish date, the Duration is changed to the Actual Duration, the Work is changed to the Actual Work, and the Cost is changed to the Actual Cost.  Keep this mantra in mind as you use the software:  Actuals Always Replace Estimates.
     
    The only way to see the original planned Finish date is to insert the Baseline Finish column.  Keep in mind that you MUST baseline your project to capture your original planned values for the project before you begin entering progress.  Without a baseline, you can never see the original planned values.  Did you save a baseline for the project?
     
    Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, February 22, 2013 5:55 PM
    Moderator

All replies

  • Yifan --
     
    The Due column to which you refer is actually the Finish column.  Apparently you or some previous PM changed the Title for the column to show Due instead of Finish.  You can float your mouse pointer over the Due column to confirm what I am saying.
     
    What you are seeing in Project 2010 is the default behavior of the tool.  Prior to progress being entered on the task, the Finish date is the planned finish date for the task.  When you enter actuals for a task, Project 2010 ALWAYS replaces planned values with actual values.  This means that the Start date is changed to the Actual Start date, the Finish date is changed to the Actual Finish date, the Duration is changed to the Actual Duration, the Work is changed to the Actual Work, and the Cost is changed to the Actual Cost.  Keep this mantra in mind as you use the software:  Actuals Always Replace Estimates.
     
    The only way to see the original planned Finish date is to insert the Baseline Finish column.  Keep in mind that you MUST baseline your project to capture your original planned values for the project before you begin entering progress.  Without a baseline, you can never see the original planned values.  Did you save a baseline for the project?
     
    Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, February 22, 2013 5:55 PM
    Moderator
  • Hello Dale,

    Thank you so much for your quick response! Your answer is clear and detailed, and it solved my issue. You are right, I renamed the "Finish" to "Due".

    Thanks again,

    Yifan

    Friday, February 22, 2013 6:07 PM
  • Yifan --
     
    You are more than welcome for the help, my friend!  :)
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, February 22, 2013 7:40 PM
    Moderator