Compare two specific tasks

[Steve268]

Hi,
this may turn out to be a really daft question and something covered as a
basic, but i really cant find an answer to my perplexing problem !

I want to introduce a custom field, and compare the dates of TWO specific
tasks within a project.
e.g. Compare start date of Task ID 100 with Start date of Task ID 120.

Is this possible?

Any help on this would be appreciated, even if it's just a response to say
that im missing the blatantly obvious !

Thanks all

Steve

 

[John]

Hi,
this may turn out to be a really daft question and something covered as a
basic, but i really cant find an answer to my perplexing problem !

I want to introduce a custom field, and compare the dates of TWO specific
tasks within a project.
e.g. Compare start date of Task ID 100 with Start date of Task ID 120.

Is this possible?

Any help on this would be appreciated, even if it's just a response to say
that im missing the blatantly obvious !

Thanks all

Steve

Steve,
Yes this is possible but it can't be done with a formula in a custom
field, you will need to use VBA. Custom field formulas only work with
data in each task, they cannot work with data from different tasks.

Hope this helps.
John
Project MVP

 

[Steve268]

Steve,
Yes this is possible but it can't be done with a formula in a custom
field, you will need to use VBA. Custom field formulas only work with
data in each task, they cannot work with data from different tasks.

Hope this helps.
John
Project MVP

Hi John,

thanks very much for the response.
Do you have any idea what the VBA would be to sort this? or can you point me
in the direction of where i can find it??

Thanks

Steve

 

[Jan De Messemaeker]

Hi,

It's hard to program a logic based on "e.g."
Is there a logiocal link between the tasks you want to compare?

 

[Steve268]

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