Forum Discussion
Solved
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 i...
- 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 --
Sounds like you are saving a new baseline every time you make a change to the project, or something akin to that. Sounds like way too much work for someone like me! 🙂 You might consider using the Interim Plan feature in the Set Baseline dialog. That would allow you to capture date changes. Just a thought. Hope this helps.
Sounds like you are saving a new baseline every time you make a change to the project, or something akin to that. Sounds like way too much work for someone like me! 🙂 You might consider using the Interim Plan feature in the Set Baseline dialog. That would allow you to capture date changes. Just a thought. Hope this helps.
Dale Howard I do appreciate your time and replies.
The reason after that is to track how many times the FinishDate has changed, that's why I am trying to find the table where these updates are stored.
Thank you in advance.
The reason after that is to track how many times the FinishDate has changed, that's why I am trying to find the table where these updates are stored.
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