There was an interesting question recently in the Microsoft Project user forum. The question was so interesting, as was my answer to the question, that I wanted to share this information with you. A Microsoft Project desktop user needed to know how to set the date formatting on a project by project basis. He stated that in some projects, he wanted to set the date formatting to display the date and the time, such as for Start dates and Finish dates. For other projects, however, he wanted to set the date formatting to show only the dates, but not the times.
The solution to this problem involves a little bit of Microsoft Project trivia. It was my pleasure to answer the user’s question, and it will be my pleasure to show you the solution in this blog post article.
First of all, you must set the date formatting option you want for the majority of your projects. For example, let’s assume that you only want to display the date in the majority of your projects, and do not want to include the time. To apply this date formatting, complete the following steps:
- Click the File and then click the Options tab in the Backstage.
- On the General page of the Project Options dialog, click the Date Format pick list and select the 1/28/09 setting (or any other setting that does not include the time), such as shown in Figure 1.
Figure 1: Project Options dialog – Date Format setting
- Click the OK button.
The Date Format setting you just applied is an “application option” that Microsoft Project applies to all projects that you open. However, there is a way to override this option setting on specific projects.
Next, open a project in which you want to apply the date formatting to display both the date AND the time, and then complete the following steps:
- Click the View tab to display the View ribbon.
- Apply a view in which you want to see the custom date formatting, such as the Gantt Chart or Tracking Gantt view, for example.
- In the Data section of the View ribbon, click the Tables pick list and select the More Tables item on the pick list.
- In the More Tables dialog, leave the current table selected, and then click the Edit button, such as shown in Figure 2.
Figure 2: More Tables dialog
- In the lower left corner of the Table Definition dialog, click the Date Format pick list and select a date formatting option that includes the time of day, such as the 1/28/09 12:33 PM option shown in Figure 3.
Figure 3: Table Definition dialog – Set the Date Format option
- Click the OK button to close the Table Definition dialog.
- Click the Apply button to apply the date formatting changes and close the More Tables dialog.
- Repeat steps #2-7 for each view in which you want to see the date and time formatting. For example, you might want to display the custom date formatting to commonly-used task views, such as the Gantt Chart and Task Usage views.
- Save and close the project.
- Open another project in which you want to apply the date and time formatting. and repeat steps #2-9 for each project.
Warning: If you work in an organization that uses Microsoft Project with Project Online or Microsoft Project Server, you can only apply the preceding project-specific date formatting setting with non-enterprise views, such as the default Gantt Chart or Tracking Gantt views. The Microsoft PPM system does not allow you to apply project-specific date formatting changes to enterprise views, such as the Enterprise Gantt Chart view or custom enterprise views created by your application administrator.