Using built in Functions

[Walt]

I have been trying to make the built in function
"ProjDateAdd(Date,duration,calendar) work and all I get is "#error". Is there
examples of these built in function being used that actually work somewhere?

 

[Mike Glen]

Hi Walt,

As you are dabbling into vba, try posting on the developer newsgroup.
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[JulieS]

Hi Walt,

I'm not sure what is causing the error but I assume you are not trying VBA
but just a straight custom field with the ProjDateAdd function. If you
could post the formula that you have entered and the fields you are using,
that may help us help you better.

In the meantime, see if the follow info helps.

In the Date1 field I have entered the following formula:
ProjDateAdd([Start],[Duration1])

I have entered a duration that I want to add to the Start date of the tasks
in the Duration1 field.
Start Date: 10 Oct 2005 8:00 am
Duration1: 2 days -- day is defined as 8 hours
Date1 (result of function) 11 Oct 2005 5:00 PM

Hope this helps. Let us know how you get along.

Julie

 

[JackD]

To add to Julie's response,
you can read this:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

Note that unlike excel, you do not enter an = sign in front of the formula.


--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

Hi Walt,

I'm not sure what is causing the error but I assume you are not trying VBA
but just a straight custom field with the ProjDateAdd function. If you
could post the formula that you have entered and the fields you are using,
that may help us help you better.

In the meantime, see if the follow info helps.

In the Date1 field I have entered the following formula:
ProjDateAdd([Start],[Duration1])

I have entered a duration that I want to add to the Start date of the tasks
in the Duration1 field.
Start Date: 10 Oct 2005 8:00 am
Duration1: 2 days -- day is defined as 8 hours
Date1 (result of function) 11 Oct 2005 5:00 PM

Hope this helps. Let us know how you get along.

Julie

I have been trying to make the built in function
"ProjDateAdd(Date,duration,calendar) work and all I get is "#error". Is
there
examples of these built in function being used that actually work
somewhere?

 

[JulieS]

Hi Jack,
Great information, particularly contrasting macros and custom fields.

Julie

 

[JackD]

Thanks. We seem to get a lot of questions about them so I figured I should
write a definitive answer (or at least try to)