Forum Discussion
Compare current value with the new inputted value
Hi Community,
As I know when editing a finishdate, the new date will replace the previous one, is there any way to compare these values before saving the changes:
- lets say the current FinishDate is 08/25/2023 If I change this date to 09/29/2023, I want to compare them to calculate the difference even before applying the changes
- If the difference is above 10days, notify me or someone else
Thank you in advance.
- Knowledgeseeker,
Pardon me for bumping in to this thread. It sounds like you are trying to do a couple of things.
1. If a task finish date is 10 (or more) days later than its previous date, you want a flag raised
2. You want a metric to show how many times a task finish date changed since "day 1" of the plan.
I doubt you'll find any kind of update table where you can extract that type of information but you could have an event based macro that gives you both pieces of data as stated above. That would be a lot easier than jockeying with the baseline data.
Just a thought.
John
- Knowledgeseeker --
You need to save a Baseline in your project before you enter progress. You can then compare the difference between the Baseline Finish date and the Finish date using the task Variance table (click View > Tables > Variance to apply it). Hope this helps.- Hi Dale Howard
As I know the maximum number of baselines is 10, in case I wanted to add more I will have to rewrite over others, in other words, I will loose the history of baselines.
Please correct me if I am wrong.
Thank you in advance.- Knowledgeseeker --
Actually, the maximum number of baselines is 11 in Microsoft Project. They are Baseline (aka Baseline 0), along with Baseline 1-10. The baseline should be the original starting values in your project, to which you can compare your current schedule to see project variance. Why do you need so many baselines, out of curiosity? Let us know and we will try to help you.
