Compare two tasks - Re-post

[Steve268]

Hi,

as with a few others, my post has disappeared so im reposting the text, and
responses so far from my query.
Would be really grateful of any further help on this !

Thanks

Steve

..............................................................


Fair Point Jan !!

I want to be able to calculate the difference in dates between tasks and
show the
output in a filed next to the task.

For example Task ID 100 - Project Meeting 1/1/07

Taks ID 320 Project update 5/1/7

(Linked through various levels of predecessors to Task 120 not directly
linked)

So a custom field is required next to the tasks to show that there are 4
days between tasks 100 and 320.

I understand that using VB this would not be dynamic, in that the coding
would have to state the task id's and would need to be changed for each
calculation needed, but this is fine.
There are only 3 key milestones that i need to look at for this, so whilst
it will not be a well used field, it's content is still worthwhile.

Thanks

Steve

 

[John]

Fair Point Jan !!

I want to be able to calculate the difference in dates between tasks and
show the
output in a filed next to the task.

For example Task ID 100 - Project Meeting 1/1/07

Taks ID 320 Project update 5/1/7

(Linked through various levels of predecessors to Task 120 not directly
linked)

So a custom field is required next to the tasks to show that there are 4
days between tasks 100 and 320.

I understand that using VB this would not be dynamic, in that the coding
would have to state the task id's and would need to be changed for each
calculation needed, but this is fine.
There are only 3 key milestones that i need to look at for this, so whilst
it will not be a well used field, it's content is still worthwhile.

Thanks

Steve

Steve,
The VBA code probably wouldn't be that complex, particularly if you only
have 3 tasks that form the basis for the compare. Yes, it could be done
with an interactive message for the user to input the task ID, but that
can be tedious. If I were writing the code, I would try to make it more
automatic. If you are willing to send me your file and a complete
description of what you want, I can write the code for you (this assumes
it is as simple as you describe). I will ask some questions.

John
Project MVP
jensenj6atatcomcastdotdotnet
(remove obvious redundancies)