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

[Sara Miller]

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]

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

 

[Sara Miller]

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

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]

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

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

 

[Sara Miller]

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

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

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

 

[Sara Miller]

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

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

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

:

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]

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

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

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

:

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