Loading...
Quick Links

Microsoft Project 16 -populating custom field with Month of Task Start Date

Home Forums Customization Microsoft Project 16 -populating custom field with Month of Task Start Date

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #414392 Reply
    Phyllis Clark
    Guest

    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.)

    #414395 Reply
    Ismet Kocaman
    Guest

    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

    #414396 Reply
    Ismet Kocaman
    Guest

    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.

    #414397 Reply
    Ismet Kocaman
    Guest

    Sorry, it is the month number that you need; just use Month( [Start] ).

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Microsoft Project 16 -populating custom field with Month of Task Start Date
Your information: