Can't Get a Field to Display the Results of My Formula

I have checked previous postings & gotten some great tips but I must be
missing something 'cause I just can't get this to work!

What I want to end up with is a field that displays the difference in days
between the date in the Finish field and the date in a custom field called
Required (Date1). I've customized the Date2 field to have this formula:
DateDiff("d",[Finish],[Date1]). The formula is accepted but there is nothing
displayed in the Date2 field. Any pointers much appreciated!

Sara

John
Wed May 23 21:22:15 CDT 2007

In article <1996494A-309A-48E5-9429-B0201D0694CE@microsoft.com>,
Sara Miller <SaraMiller@discussions.microsoft.com> wrote:

> I have checked previous postings & gotten some great tips but I must be
> missing something 'cause I just can't get this to work!
>
> What I want to end up with is a field that displays the difference in days
> between the date in the Finish field and the date in a custom field called
> Required (Date1). I've customized the Date2 field to have this formula:
> DateDiff("d",[Finish],[Date1]). The formula is accepted but there is nothing
> displayed in the Date2 field. Any pointers much appreciated!
>
> Sara

Sara,
There is nothing wrong with the formula itself so the formula will be
"accepted". However, you are trying to put non-date information into a
spare date field and that won't work. Try putting your formula in a
spare text field.

John
Project MVP

SaraMiller
Thu May 24 10:00:01 CDT 2007

Thanks for the reply John. Actually I did try it in a Text field with the
same result.
Sara

"John" wrote:

> In article <1996494A-309A-48E5-9429-B0201D0694CE@microsoft.com>,
> Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
>
> > I have checked previous postings & gotten some great tips but I must be
> > missing something 'cause I just can't get this to work!
> >
> > What I want to end up with is a field that displays the difference in days
> > between the date in the Finish field and the date in a custom field called
> > Required (Date1). I've customized the Date2 field to have this formula:
> > DateDiff("d",[Finish],[Date1]). The formula is accepted but there is nothing
> > displayed in the Date2 field. Any pointers much appreciated!
> >
> > Sara
>
> Sara,
> There is nothing wrong with the formula itself so the formula will be
> "accepted". However, you are trying to put non-date information into a
> spare date field and that won't work. Try putting your formula in a
> spare text field.
>
> John
> Project MVP
>

John
Thu May 24 12:49:52 CDT 2007

In article <9CAA3CC6-BCAA-4F72-8CAC-AD38823AAF37@microsoft.com>,
Sara Miller <SaraMiller@discussions.microsoft.com> wrote:

> Thanks for the reply John. Actually I did try it in a Text field with the
> same result.
> Sara

Sara,
So are telling me that you put your formula in a spare text field and it
did NOT work there either? That's strange because it works fine for me.
I would check your data very carefully to make sure it is valid. Also,
if you are trying to do this on a master file with inserted projects,
the formula will only apply to tasks that are actually part of the
master. For a formula to work on tasks in a subproject file that is
inserted into a master, the formula must reside in the subproject file
itself.

John
Project MVP
>
> "John" wrote:
>
> > In article <1996494A-309A-48E5-9429-B0201D0694CE@microsoft.com>,
> > Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
> >
> > > I have checked previous postings & gotten some great tips but I must be
> > > missing something 'cause I just can't get this to work!
> > >
> > > What I want to end up with is a field that displays the difference in
> > > days
> > > between the date in the Finish field and the date in a custom field
> > > called
> > > Required (Date1). I've customized the Date2 field to have this formula:
> > > DateDiff("d",[Finish],[Date1]). The formula is accepted but there is
> > > nothing
> > > displayed in the Date2 field. Any pointers much appreciated!
> > >
> > > Sara
> >
> > Sara,
> > There is nothing wrong with the formula itself so the formula will be
> > "accepted". However, you are trying to put non-date information into a
> > spare date field and that won't work. Try putting your formula in a
> > spare text field.
> >
> > John
> > Project MVP
> >

SaraMiller
Fri May 25 09:41:01 CDT 2007

Ahah! I think you've got itâ??I was trying this in an inserted sub-project. I
will test this out as soon as I get back in the office on Tuesday.
Thanks!
Sara

"John" wrote:

> In article <9CAA3CC6-BCAA-4F72-8CAC-AD38823AAF37@microsoft.com>,
> Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
>
> > Thanks for the reply John. Actually I did try it in a Text field with the
> > same result.
> > Sara
>
> Sara,
> So are telling me that you put your formula in a spare text field and it
> did NOT work there either? That's strange because it works fine for me.
> I would check your data very carefully to make sure it is valid. Also,
> if you are trying to do this on a master file with inserted projects,
> the formula will only apply to tasks that are actually part of the
> master. For a formula to work on tasks in a subproject file that is
> inserted into a master, the formula must reside in the subproject file
> itself.
>
> John
> Project MVP
> >
> > "John" wrote:
> >
> > > In article <1996494A-309A-48E5-9429-B0201D0694CE@microsoft.com>,
> > > Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
> > >
> > > > I have checked previous postings & gotten some great tips but I must be
> > > > missing something 'cause I just can't get this to work!
> > > >
> > > > What I want to end up with is a field that displays the difference in
> > > > days
> > > > between the date in the Finish field and the date in a custom field
> > > > called
> > > > Required (Date1). I've customized the Date2 field to have this formula:
> > > > DateDiff("d",[Finish],[Date1]). The formula is accepted but there is
> > > > nothing
> > > > displayed in the Date2 field. Any pointers much appreciated!
> > > >
> > > > Sara
> > >
> > > Sara,
> > > There is nothing wrong with the formula itself so the formula will be
> > > "accepted". However, you are trying to put non-date information into a
> > > spare date field and that won't work. Try putting your formula in a
> > > spare text field.
> > >
> > > John
> > > Project MVP
> > >
>

SaraMiller
Tue May 29 17:00:01 CDT 2007

Success! Not only was I able to create the formula in the individual file,
but I also customized it to display a graphical indicator (red, yellow, green
dots) in the Text field. Once I created this in the individual file it is
also displayed in the Master.

Thanks so much for your help John!
Sara

"Sara Miller" wrote:

> Ahah! I think you've got itâ??I was trying this in an inserted sub-project. I
> will test this out as soon as I get back in the office on Tuesday.
> Thanks!
> Sara
>
> "John" wrote:
>
> > In article <9CAA3CC6-BCAA-4F72-8CAC-AD38823AAF37@microsoft.com>,
> > Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
> >
> > > Thanks for the reply John. Actually I did try it in a Text field with the
> > > same result.
> > > Sara
> >
> > Sara,
> > So are telling me that you put your formula in a spare text field and it
> > did NOT work there either? That's strange because it works fine for me.
> > I would check your data very carefully to make sure it is valid. Also,
> > if you are trying to do this on a master file with inserted projects,
> > the formula will only apply to tasks that are actually part of the
> > master. For a formula to work on tasks in a subproject file that is
> > inserted into a master, the formula must reside in the subproject file
> > itself.
> >
> > John
> > Project MVP
> > >
> > > "John" wrote:
> > >
> > > > In article <1996494A-309A-48E5-9429-B0201D0694CE@microsoft.com>,
> > > > Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
> > > >
> > > > > I have checked previous postings & gotten some great tips but I must be
> > > > > missing something 'cause I just can't get this to work!
> > > > >
> > > > > What I want to end up with is a field that displays the difference in
> > > > > days
> > > > > between the date in the Finish field and the date in a custom field
> > > > > called
> > > > > Required (Date1). I've customized the Date2 field to have this formula:
> > > > > DateDiff("d",[Finish],[Date1]). The formula is accepted but there is
> > > > > nothing
> > > > > displayed in the Date2 field. Any pointers much appreciated!
> > > > >
> > > > > Sara
> > > >
> > > > Sara,
> > > > There is nothing wrong with the formula itself so the formula will be
> > > > "accepted". However, you are trying to put non-date information into a
> > > > spare date field and that won't work. Try putting your formula in a
> > > > spare text field.
> > > >
> > > > John
> > > > Project MVP
> > > >
> >

John
Wed May 30 13:45:27 CDT 2007

In article <8A932B9B-E0AC-46A0-8C16-F7423FF72083@microsoft.com>,
Sara Miller <SaraMiller@discussions.microsoft.com> wrote:

> Success! Not only was I able to create the formula in the individual file,
> but I also customized it to display a graphical indicator (red, yellow, green
> dots) in the Text field. Once I created this in the individual file it is
> also displayed in the Master.
>
> Thanks so much for your help John!
> Sara

Sara,
You're welcome although I see you now have a new problem (your new post
today).

John
>
> "Sara Miller" wrote:
>
> > Ahah! I think you've got itâ??I was trying this in an inserted sub-project. I
> > will test this out as soon as I get back in the office on Tuesday.
> > Thanks!
> > Sara
> >
> > "John" wrote:
> >
> > > In article <9CAA3CC6-BCAA-4F72-8CAC-AD38823AAF37@microsoft.com>,
> > > Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
> > >
> > > > Thanks for the reply John. Actually I did try it in a Text field with
> > > > the
> > > > same result.
> > > > Sara
> > >
> > > Sara,
> > > So are telling me that you put your formula in a spare text field and it
> > > did NOT work there either? That's strange because it works fine for me.
> > > I would check your data very carefully to make sure it is valid. Also,
> > > if you are trying to do this on a master file with inserted projects,
> > > the formula will only apply to tasks that are actually part of the
> > > master. For a formula to work on tasks in a subproject file that is
> > > inserted into a master, the formula must reside in the subproject file
> > > itself.
> > >
> > > John
> > > Project MVP
> > > >
> > > > "John" wrote:
> > > >
> > > > > In article <1996494A-309A-48E5-9429-B0201D0694CE@microsoft.com>,
> > > > > Sara Miller <SaraMiller@discussions.microsoft.com> wrote:
> > > > >
> > > > > > I have checked previous postings & gotten some great tips but I
> > > > > > must be
> > > > > > missing something 'cause I just can't get this to work!
> > > > > >
> > > > > > What I want to end up with is a field that displays the difference
> > > > > > in
> > > > > > days
> > > > > > between the date in the Finish field and the date in a custom field
> > > > > > called
> > > > > > Required (Date1). I've customized the Date2 field to have this
> > > > > > formula:
> > > > > > DateDiff("d",[Finish],[Date1]). The formula is accepted but there
> > > > > > is
> > > > > > nothing
> > > > > > displayed in the Date2 field. Any pointers much appreciated!
> > > > > >
> > > > > > Sara
> > > > >
> > > > > Sara,
> > > > > There is nothing wrong with the formula itself so the formula will be
> > > > > "accepted". However, you are trying to put non-date information into
> > > > > a
> > > > > spare date field and that won't work. Try putting your formula in a
> > > > > spare text field.
> > > > >
> > > > > John
> > > > > Project MVP
> > > > >
> > >