Using Functions in Header

[Sue]

Situation: I have a report (actually a printed view) that uses a date of
[Status Date] plus 4 weeks. I am using custom task fields to filter the
appropriate tasks.

Issue: I have to manually change the date in the header so that it reads the
correct date of the filter. How do I enter a formula in the header? (such
as ProjDateAdd([Status Date], "4w"). Another option I considered (but
haven't been successful with) is using a calculated custom Project Field.

Any suggestions are welcome.
Thanks,
Sue

 

[Brian K - Project MVP]

Situation: I have a report (actually a printed view) that uses a date of
[Status Date] plus 4 weeks. I am using custom task fields to filter the
appropriate tasks.

Issue: I have to manually change the date in the header so that it reads
the
correct date of the filter. How do I enter a formula in the header? (such
as ProjDateAdd([Status Date], "4w"). Another option I considered (but
haven't been successful with) is using a calculated custom Project Field.

Any suggestions are welcome.
Thanks,
Sue

Do you mean that you want the field name\title to be conrolled by a
formula? If so the only way to do that would be to use VBA like the
following:

Sub FieldNametoDate()
CustomFieldRename FieldID:=pjCustomResourceText1, _
NewName:=Format(ActiveProject.StatusDate + 21, Format:="mm-dd-yy")
End Sub

This renames the Text1 field to the Status Date + 21 days in a format that
is acceptable as a field name.