Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Format - Forced Time Display Option? 2

Status
Not open for further replies.

mmarquardt

Computer
Joined
Jun 12, 2008
Messages
1
Location
US
I manage a program-wide deployment schedule where start and finish times are critical. When others pull up my schedule, some see only dates because they have their OPTION-TOOLS-VIEW-DATE FORMAT set to dates only.

Is there an MS Project option or way to force a specific project to display times no matter who pulls it up?

 
You can use VBA to do this. Add

OptionsView DateFormat:=8

to the Project_Open macro in the schedule.

TTFN

FAQ731-376
 
There is a way to do this without the macro. It involves modifying the options within the tables as opposed to the over-all MS Project options which is under tools. Try this:
1. Open your project
2. Go to the View that you want to leverage. This View will contain the Table you want to leverage.
3. Click on >View, >Table, >More Tables, >Edit
4. In the Table Definition dialogue box, there is a field for Date Format: Select the date format that you would like all users to see (this could include time)
5. Click on OK, Apply, Save and close.

Now, when any user opens this file and goes to this view, the Start and Finish columns will display the date format just as you set within the Table Definition dialogue box.

Hope this helps!!

J Black
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top