JulieS
Wed Jun 13 16:54:04 CDT 2007
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
"SigR" <SigR@discussions.microsoft.com> wrote in message
news:C88D9548-2EAF-46A6-9EEE-B02AA1A22241@microsoft.com...
> 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
>
> "JulieS" wrote:
>
>> 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" <SigR@discussions.microsoft.com> wrote in message
>> news:434A05A0-8702-4330-A2C1-5D08D2767AE8@microsoft.com...
>> >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
>>
>>
>>