Date format with and without Time in same project

[SigR]

I would like to see all my dates without time ("7/03/06") in my Gantt, but,
I would like a footer on my reports that shows the last saved date AND TIME
for the file ( "C:\My Documents\Test ABC\ABC01 Project.mpp as of 8/25/06 2:11
PM").
"Tools>Options>View - Date format:" seems to control them both.
Is there any way I can have different formatting in the footer?

SigR

 

[JulieS]

Hello SigR,

The only work around I could come up with is to use a spare text field
(Text30) with the following formula:

Format([Last Update],"MMM DD, YYYY hh:mm")

Make sure the calculation for the summary row is set to use formula.
Then in the page setup footer tab, select the text field you used for
the formula to display in the footer.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[SigR]

Yes, Thanks, just what the doctor ordered. I was trying to play around with
VBA to get current date/time and insert it into a cell. This is MUCH better.

SigR

Hello SigR,

The only work around I could come up with is to use a spare text field
(Text30) with the following formula:

Format([Last Update],"MMM DD, YYYY hh:mm")

Make sure the calculation for the summary row is set to use formula.
Then in the page setup footer tab, select the text field you used for
the formula to display in the footer.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

I would like to see all my dates without time ("7/03/06") in my Gantt,
but,
I would like a footer on my reports that shows the last saved date AND
TIME
for the file ( "C:\My Documents\Test ABC\ABC01 Project.mpp as of
8/25/06 2:11
PM").
"Tools>Options>View - Date format:" seems to control them both.
Is there any way I can have different formatting in the footer?

SigR

 

[JulieS]

You're most welcome SigR and thanks for the feedback.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Yes, Thanks, just what the doctor ordered. I was trying to play
around with
VBA to get current date/time and insert it into a cell. This is MUCH
better.

SigR

Hello SigR,

The only work around I could come up with is to use a spare text
field
(Text30) with the following formula:

Format([Last Update],"MMM DD, YYYY hh:mm")

Make sure the calculation for the summary row is set to use formula.
Then in the page setup footer tab, select the text field you used for
the formula to display in the footer.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

I would like to see all my dates without time ("7/03/06") in my
Gantt,
but,
I would like a footer on my reports that shows the last saved date
AND
TIME
for the file ( "C:\My Documents\Test ABC\ABC01 Project.mpp as of
8/25/06 2:11
PM").
"Tools>Options>View - Date format:" seems to control them both.
Is there any way I can have different formatting in the footer?

SigR