Compare two tasks - Re-post

TheMSsForum.com: The Microsoft Software Forum

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






"Jan De Messemaeker" wrote:

> Hi,
>
> It's hard to program a logic based on "e.g."
> Is there a logiocal link between the tasks you want to compare?
>
> --
> Jan De Messemaeker
> Microsoft Project MVP
> http://users.online.be/prom-ade
> "Steve268" <Steve268@discussions.microsoft.com> wrote in message
> news:E25B15D3-B53F-4B20-9779-0E609F6C6195@microsoft.com...
> >
> >
> > "John" wrote:
> >
> >> In article <F4115E28-1365-4452-9A2A-A3FB977207C6@microsoft.com>,
> >> Steve268 <Steve268@discussions.microsoft.com> wrote:
> >>
> >> > 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
> >>
> >
> > 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
>
>
>
Top

Re: Compare two tasks - Re-post by John

John
Wed Jun 13 10:31:37 CDT 2007

In article <FBF9CB15-9F85-42DD-ABD1-C3722DD432BD@microsoft.com>,
Steve268 <Steve268@discussions.microsoft.com> wrote:

>
> 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)
>
>
>
>
>
>
> "Jan De Messemaeker" wrote:
>
> > Hi,
> >
> > It's hard to program a logic based on "e.g."
> > Is there a logiocal link between the tasks you want to compare?
> >
> > --
> > Jan De Messemaeker
> > Microsoft Project MVP
> > http://users.online.be/prom-ade
> > "Steve268" <Steve268@discussions.microsoft.com> wrote in message
> > news:E25B15D3-B53F-4B20-9779-0E609F6C6195@microsoft.com...
> > >
> > >
> > > "John" wrote:
> > >
> > >> In article <F4115E28-1365-4452-9A2A-A3FB977207C6@microsoft.com>,
> > >> Steve268 <Steve268@discussions.microsoft.com> wrote:
> > >>
> > >> > 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
> > >>
> > >
> > > 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
> >
> >
> >
Top