Home › Forums › Customization › Microsoft Project 16 -populating custom field with Month of Task Start Date
I am trying to populate a custom field with just the Month of the Task start date(e.g. 1 for Jan, 2 for Feb, etc.)
The following formula entered to a custom text field (e.g. Text1) will return three-letter month names to the field: Left( ProjDateConv( [Start], pjDate_mmm_dd), 3 )
Hope this helps. Ismet
PS. The functions Format and MonthName can also be used for this purpose. Note that the MonthName function is not recognized by some product versions.
Sorry, it is the month number that you need; just use Month( [Start] ).
Mail (will not be published) (required):
Please complete this equation so we know you’re not a robot. 6 + 4 =
Please enter your username or email address. You will receive a link to create a new password via email.
Enter the destination URL
Or link to existing content