Duration of Customer Date Fields

[Goose]

Hello. I have a project plan that I am using 2 custom date fields. I want
to calculate the duration of these 2 date fields and I cannot seem to get the
actual duration, but I am able to get the variance using
ProjDateDiff([Date31,Date2]). I would think that this is a simple solution,
but I am not able to solve it. I also created a new date field (Date3)
(Date1 minus one day) ProjDateSub([Date1],1) and then used the same
ProjDateDiff([Date3],[Date2]) but that came up with the same variance as
before. Is there anyway to get the actual duration of 2 custom date fields?

 

[Jan De Messemaeker]

Hi Goose,

What is the duration of a date field?
A duration IMHO is a difference between two points in time, how can one date
have a duration?
Hope this helps,

 

[Goose]

Jan, there are 2 date fields and I need to find the duration of the 2. Think
of this in this manner Date1=Start, Date2=Finish. The Custom Duration field
I am using I would like for it to act as Duration does when calculating the
Duration of Start and Finish.

So, in other words what I want is:

Duration1=the time elapsed for Date1 and Date2

as it would for:

Duration=the time elapsed for Start and Finish.

Does that make more sense?

Hi Goose,

What is the duration of a date field?
A duration IMHO is a difference between two points in time, how can one date
have a duration?
Hope this helps,

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Hello. I have a project plan that I am using 2 custom date fields. I
want
to calculate the duration of these 2 date fields and I cannot seem to get
the
actual duration, but I am able to get the variance using
ProjDateDiff([Date31,Date2]). I would think that this is a simple
solution,
but I am not able to solve it. I also created a new date field (Date3)
(Date1 minus one day) ProjDateSub([Date1],1) and then used the same
ProjDateDiff([Date3],[Date2]) but that came up with the same variance as
before. Is there anyway to get the actual duration of 2 custom date
fields?

 

[Jan De Messemaeker]

Hi,

Sorry but that is exactly what you call the variation,
ProjDateDiff([Date1],[Date2])
Isn't it?

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Jan, there are 2 date fields and I need to find the duration of the 2.
Think
of this in this manner Date1=Start, Date2=Finish. The Custom Duration
field
I am using I would like for it to act as Duration does when calculating
the
Duration of Start and Finish.

So, in other words what I want is:

Duration1=the time elapsed for Date1 and Date2

as it would for:

Duration=the time elapsed for Start and Finish.

Does that make more sense?

Hi Goose,

What is the duration of a date field?
A duration IMHO is a difference between two points in time, how can one
date
have a duration?
Hope this helps,

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Hello. I have a project plan that I am using 2 custom date fields. I
want
to calculate the duration of these 2 date fields and I cannot seem to
get
the
actual duration, but I am able to get the variance using
ProjDateDiff([Date31,Date2]). I would think that this is a simple
solution,
but I am not able to solve it. I also created a new date field (Date3)
(Date1 minus one day) ProjDateSub([Date1],1) and then used the same
ProjDateDiff([Date3],[Date2]) but that came up with the same variance
as
before. Is there anyway to get the actual duration of 2 custom date
fields?

 

[Goose]

Jan,

Yes. That is the variance. That is not what I am trying to achieve.

Here is what I want, but cannot get the formula to do it (all fields are
custom):

Date1=07/01/2007 Date2=07/03/2007 Duration1=3 days

Here is what I am getting:

Date1=07/01/2007 Date2=07/03/2007 Duration1=2 days

This is NOT what I want becuase it is doing the difference in days (2)
rather than the total days (3).

Is there a formula I can use to get the first example of a total of 3 days?

Hi,

Sorry but that is exactly what you call the variation,
ProjDateDiff([Date1],[Date2])
Isn't it?

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Jan, there are 2 date fields and I need to find the duration of the 2.
Think
of this in this manner Date1=Start, Date2=Finish. The Custom Duration
field
I am using I would like for it to act as Duration does when calculating
the
Duration of Start and Finish.

So, in other words what I want is:

Duration1=the time elapsed for Date1 and Date2

as it would for:

Duration=the time elapsed for Start and Finish.

Does that make more sense?

Hi Goose,

What is the duration of a date field?
A duration IMHO is a difference between two points in time, how can one
date
have a duration?
Hope this helps,

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Hello. I have a project plan that I am using 2 custom date fields. I
want
to calculate the duration of these 2 date fields and I cannot seem to
get
the
actual duration, but I am able to get the variance using
ProjDateDiff([Date31,Date2]). I would think that this is a simple
solution,
but I am not able to solve it. I also created a new date field (Date3)
(Date1 minus one day) ProjDateSub([Date1],1) and then used the same
ProjDateDiff([Date3],[Date2]) but that came up with the same variance
as
before. Is there anyway to get the actual duration of 2 custom date
fields?

 

[Jan De Messemaeker]

Hi,

Yes. Instead of Date1 and Date2 use Start1 and Finish1.
Remember all dates iun Proejct are including time of day; using Finish1 for
the finish ensures taht it will be positioned end of day so you'll get 3.
It's not the formula, it's the input.
HTH

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Jan,

Yes. That is the variance. That is not what I am trying to achieve.

Here is what I want, but cannot get the formula to do it (all fields are
custom):

Date1=07/01/2007 Date2=07/03/2007 Duration1=3 days

Here is what I am getting:

Date1=07/01/2007 Date2=07/03/2007 Duration1=2 days

This is NOT what I want becuase it is doing the difference in days (2)
rather than the total days (3).

Is there a formula I can use to get the first example of a total of 3
days?

Hi,

Sorry but that is exactly what you call the variation,
ProjDateDiff([Date1],[Date2])
Isn't it?

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Jan, there are 2 date fields and I need to find the duration of the 2.
Think
of this in this manner Date1=Start, Date2=Finish. The Custom Duration
field
I am using I would like for it to act as Duration does when calculating
the
Duration of Start and Finish.

So, in other words what I want is:

Duration1=the time elapsed for Date1 and Date2

as it would for:

Duration=the time elapsed for Start and Finish.

Does that make more sense?

:

Hi Goose,

What is the duration of a date field?
A duration IMHO is a difference between two points in time, how can
one
date
have a duration?
Hope this helps,

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Hello. I have a project plan that I am using 2 custom date fields.
I
want
to calculate the duration of these 2 date fields and I cannot seem
to
get
the
actual duration, but I am able to get the variance using
ProjDateDiff([Date31,Date2]). I would think that this is a simple
solution,
but I am not able to solve it. I also created a new date field
(Date3)
(Date1 minus one day) ProjDateSub([Date1],1) and then used the same
ProjDateDiff([Date3],[Date2]) but that came up with the same
variance
as
before. Is there anyway to get the actual duration of 2 custom date
fields?

 

[Goose]

THAT'S IT!

Thank you so much Jan!

Have a great day!

Hi,

Yes. Instead of Date1 and Date2 use Start1 and Finish1.
Remember all dates iun Proejct are including time of day; using Finish1 for
the finish ensures taht it will be positioned end of day so you'll get 3.
It's not the formula, it's the input.
HTH

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Jan,

Yes. That is the variance. That is not what I am trying to achieve.

Here is what I want, but cannot get the formula to do it (all fields are
custom):

Date1=07/01/2007 Date2=07/03/2007 Duration1=3 days

Here is what I am getting:

Date1=07/01/2007 Date2=07/03/2007 Duration1=2 days

This is NOT what I want becuase it is doing the difference in days (2)
rather than the total days (3).

Is there a formula I can use to get the first example of a total of 3
days?

Hi,

Sorry but that is exactly what you call the variation,
ProjDateDiff([Date1],[Date2])
Isn't it?

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Jan, there are 2 date fields and I need to find the duration of the 2.
Think
of this in this manner Date1=Start, Date2=Finish. The Custom Duration
field
I am using I would like for it to act as Duration does when calculating
the
Duration of Start and Finish.

So, in other words what I want is:

Duration1=the time elapsed for Date1 and Date2

as it would for:

Duration=the time elapsed for Start and Finish.

Does that make more sense?

:

Hi Goose,

What is the duration of a date field?
A duration IMHO is a difference between two points in time, how can
one
date
have a duration?
Hope this helps,

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Hello. I have a project plan that I am using 2 custom date fields.
I
want
to calculate the duration of these 2 date fields and I cannot seem
to
get
the
actual duration, but I am able to get the variance using
ProjDateDiff([Date31,Date2]). I would think that this is a simple
solution,
but I am not able to solve it. I also created a new date field
(Date3)
(Date1 minus one day) ProjDateSub([Date1],1) and then used the same
ProjDateDiff([Date3],[Date2]) but that came up with the same
variance
as
before. Is there anyway to get the actual duration of 2 custom date
fields?