Using built in Functions

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
Fri Oct 07 15:39:35 CDT 2005

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


Walt wrote:
> 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
Fri Oct 07 18:02:08 CDT 2005

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

"Walt" <Walt@discussions.microsoft.com> wrote in message
news:428AD185-5B25-4BC7-8E0B-6921FBDD461E@microsoft.com...
>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?

JackD
Fri Oct 07 19:34:09 CDT 2005

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
.
"JulieS" <passport6847 at maine dot rr dot com> wrote in message
news:OHsojM5yFHA.736@tk2msftngp13.phx.gbl...
> 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
>
> "Walt" <Walt@discussions.microsoft.com> wrote in message
> news:428AD185-5B25-4BC7-8E0B-6921FBDD461E@microsoft.com...
> >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
Fri Oct 07 20:44:07 CDT 2005

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

Julie
"JackD" <momokuri@gmail> wrote in message
news:uZznAA6yFHA.2132@TK2MSFTNGP15.phx.gbl...
> 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.

JackD
Sat Oct 08 00:52:27 CDT 2005

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)

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
.
"JulieS" <passport6847 at maine dot rr dot com> wrote in message
news:eQ7KEn6yFHA.3892@TK2MSFTNGP12.phx.gbl...
> Hi Jack,
> Great information, particularly contrasting macros and custom fields.
>
> Julie
> "JackD" <momokuri@gmail> wrote in message
> news:uZznAA6yFHA.2132@TK2MSFTNGP15.phx.gbl...
> > 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.
>
>