Prev: Baseline comparison
Next: Not changing end date of task
From: Dean C on 29 Apr 2008 14:53
I came across this when searching for my posts. I found what I was looking
for quite awhile ago. The answer is to go to help and search for Project
Functions. There is an error in the help file though. In DateAdd, "interval",
is listed as "Integer" when in fact it can only be "s", "m", "h", "d",
"w","M", "q", "y".

"JulieS" wrote:

> Hi Dean C,
>
> You're welcome and thanks for the feedback. Good luck with your quest.
>
> Julie
> "Dean C" <DeanC(a)discussions.microsoft.com> wrote in message
> news:97644940-0821-401B-B8E3-7A716A391AF9(a)microsoft.com...
> > JulieS,
> > Thanks, the value Jack used is incorrect for a date value of "NA", but
> > it
> > gave me a starting point for a number. The correct number is
> > 4294967295,
> > which is (2 to the 32nd power - 1). Jack forgot to subtract one, but
> > did
> > provide the correct formula.
> >
> > As I recall, this is the third thing I've learned in this news group
> > and I
> > learned at least one of the other two from you also. I gave you full
> > credit
> > even though my real quest was for good Jet expression references.
> >
> > Access also uses Jet expression and includes an Expression Builder, so
> > I'll
> > resort to that. I haven't played with databases (other than MSP) since
> > dBase
> > III, so this should be interesting.
> >
> > "JulieS" wrote:
> >
> >> Hi Dean C,
> >>
> >> For the NA issue see MVP Jack Dahlgren's page on calculated fields
> >> at:
> >>
> >> http://masamiki.com/project/customfieldFAQ.htm
> >>
> >> I hope this helps. Let us know how you get along.
> >>
> >> Julie
> >> "Dean C" <DeanC(a)discussions.microsoft.com> wrote in message
> >> news:A4D435C4-4D77-40E6-9633-3B66D3EC7369(a)microsoft.com...
> >> > Where are acceptable expressions for MS Project custom fields
> >> > defined?
> >> > Mike
> >> > Glen touched on the subject a few years ago, but I can't find any
> >> > details.
> >> >
> >> > I know that custom fields in Project use the Jet expression format,
> >> > but have
> >> > been unable to find a list of acceptable terms. For example,
> >> > iif([Actual
> >> > Start]="NA","true","false"), results in #ERROR, but so does
> >> > iif(iserror([ACT([Actual Start]="NA"),"true","false"). There is a
> >> > value of
> >> > "NA" in the field, but Jet Expression doesn't like it.
> >>
> >>
> >>
>
>
>
From: JulieS on 4 May 2008 10:29
Hi Dean,

I'm glad you found the information you were looking for. Thanks also
for pointing out the error in the help file. You're right it's a bit
confusing when it says: "Integer: String expressions that is the
interval of time you want to add."

Julie

"Dean C" <DeanC(a)discussions.microsoft.com> wrote in message
news:48457381-0AA2-4F63-906B-A75AA74C1D3C(a)microsoft.com...
>I came across this when searching for my posts. I found what I was
>looking
> for quite awhile ago. The answer is to go to help and search for
> Project
> Functions. There is an error in the help file though. In DateAdd,
> "interval",
> is listed as "Integer" when in fact it can only be "s", "m", "h",
> "d",
> "w","M", "q", "y".
>
> "JulieS" wrote:
>
>> Hi Dean C,
>>
>> You're welcome and thanks for the feedback. Good luck with your
>> quest.
>>
>> Julie
>> "Dean C" <DeanC(a)discussions.microsoft.com> wrote in message
>> news:97644940-0821-401B-B8E3-7A716A391AF9(a)microsoft.com...
>> > JulieS,
>> > Thanks, the value Jack used is incorrect for a date value of
>> > "NA", but
>> > it
>> > gave me a starting point for a number. The correct number is
>> > 4294967295,
>> > which is (2 to the 32nd power - 1). Jack forgot to subtract one,
>> > but
>> > did
>> > provide the correct formula.
>> >
>> > As I recall, this is the third thing I've learned in this news
>> > group
>> > and I
>> > learned at least one of the other two from you also. I gave you
>> > full
>> > credit
>> > even though my real quest was for good Jet expression references.
>> >
>> > Access also uses Jet expression and includes an Expression
>> > Builder, so
>> > I'll
>> > resort to that. I haven't played with databases (other than MSP)
>> > since
>> > dBase
>> > III, so this should be interesting.
>> >
>> > "JulieS" wrote:
>> >
>> >> Hi Dean C,
>> >>
>> >> For the NA issue see MVP Jack Dahlgren's page on calculated
>> >> fields
>> >> at:
>> >>
>> >> http://masamiki.com/project/customfieldFAQ.htm
>> >>
>> >> I hope this helps. Let us know how you get along.
>> >>
>> >> Julie
>> >> "Dean C" <DeanC(a)discussions.microsoft.com> wrote in message
>> >> news:A4D435C4-4D77-40E6-9633-3B66D3EC7369(a)microsoft.com...
>> >> > Where are acceptable expressions for MS Project custom fields
>> >> > defined?
>> >> > Mike
>> >> > Glen touched on the subject a few years ago, but I can't find
>> >> > any
>> >> > details.
>> >> >
>> >> > I know that custom fields in Project use the Jet expression
>> >> > format,
>> >> > but have
>> >> > been unable to find a list of acceptable terms. For example,
>> >> > iif([Actual
>> >> > Start]="NA","true","false"), results in #ERROR, but so does
>> >> > iif(iserror([ACT([Actual Start]="NA"),"true","false"). There
>> >> > is a
>> >> > value of
>> >> > "NA" in the field, but Jet Expression doesn't like it.
>> >>
>> >>
>> >>
>>
>>
>>


 | 
Pages: 1
Prev: Baseline comparison
Next: Not changing end date of task