0

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

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

Viewing 3 reply threads
  • Author
    Posts
    • 12/26/2018 at 11:05 am #414392
      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.)

    • 12/26/2018 at 4:35 pm #414395
      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

    • 12/26/2018 at 4:46 pm #414396
      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.

    • 12/26/2018 at 4:50 pm #414397
      Ismet Kocaman
      Guest

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

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.