Custom Date and/or Duration Field

[Diane]

I am trying to create a custom date field. I want to
calculate the difference between the Constraint date and
the Start date on a task. In the formula section of the
custom field, I use the following fields:

[Constraint Date]-[Start]

When I display the field in the Gantt view, the custom
field is filled with !!ERROR message.

Can someone please help?

 

[Gérard DUCOURET]

Hello Diane,
I think you choosed a wrong type of custom field : the result of your formula is not a date but a
number (of days) so you have to use a NumberX field.

Hope this help,

Gérard Ducouret

 

[Jan De Messemaeker]

Hi Diane,

You do not subtract dates like that, there are functions to do that.
In the Formula window, look up Function, Date/Time, and look fo rhelp on
DateDiff and ProjDateDiff.
The latter can take a base calendar into account.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Jack D.]

I find it is always best to start debugging a custom formula using a text
field. It avoids datatype errors.
Once it works in a text field then try other types of fields.

-Jack

Hello Diane,
I think you choosed a wrong type of custom field : the result of your
formula is not a date but a number (of days) so you have to use a NumberX
field.

Hope this help,

Gérard Ducouret

I am trying to create a custom date field. I want to
calculate the difference between the Constraint date and
the Start date on a task. In the formula section of the
custom field, I use the following fields:

[Constraint Date]-[Start]

When I display the field in the Gantt view, the custom
field is filled with !!ERROR message.

Can someone please help?

+++++++++++++++++++