Forum Discussion
How to display the date as month/year only
Just for reference, Project calculates all scheduling dates to the nearest minute regardless of how dates are displayed.
To answer your question, do this.
1. First create a custom Text field (e.g. Text1) with the following formula:
Text1=Month([Start]) & "/" & year([Start])
2. Go to Format > Bar Styles group > Format and in the lower part of the Format Bar Styles window select the "Text" tab and set it to the text field you customized. Set the text display the same for any other Gantt Bars where you want only the month and year to be shown.
You should see a display similar to this. Note, the Text1 field does not need to be added as a column in the view, it is shown for illustrative purposes only.
Hope this helps.
John
Just for reference, Project calculates all scheduling dates to the nearest minute regardless of how dates are displayed.
To answer your question, do this.
1. First create a custom Text field (e.g. Text1) with the following formula:
Text1=Month([Start]) & "/" & year([Start])
2. Go to Format > Bar Styles group > Format and in the lower part of the Format Bar Styles window select the "Text" tab and set it to the text field you customized. Set the text display the same for any other Gantt Bars where you want only the month and year to be shown.
You should see a display similar to this. Note, the Text1 field does not need to be added as a column in the view, it is shown for illustrative purposes only.
Hope this helps.
John
I just cant believe that this the way that MS has designed it.
It feels like an ugly workaround.
In Word and Excel it is so much simpler: select custom format, enter MM/YYYY and you are done.
Hello Microsoft, anyone listening? Time to get out of bed and do something for your customers...
You're welcome and thanks for the feedback.
Keep in mind that Word and Excel are "generic" (open format) whereas Project is a strictly defined database format, although I do agree it would be nice to have more options for date format. The best way to get Microsoft to listen is to post your request to the Project UserChannel at:
https://microsoftproject.uservoice.com/forums/914203-project-for-the-webJohn