0

Need formula to convert start date into quarter of the year in a custom field

Home › Forums › Microsoft Project Discussion Forum › Need formula to convert start date into quarter of the year in a custom field

Tagged: 

Viewing 8 reply threads
  • Author
    Posts
    • 05/07/2015 at 3:02 pm #339043
      Jan Whitehead
      Participant

      Has anyone created a formula that will convert a start date into a quarter of the year in a custom field? If so, would you mind to share or explain how it was done?

    • 05/07/2015 at 8:51 pm #339269
      Avatar photoLarry Christofaro
      Participant

      Jan, you can do this in two steps. Use the Month command “Month([Start])” to get the month number. Then you can evaluate the month number to determine the quarter. Hope that helps.

    • 05/08/2015 at 7:08 am #339584
      Avatar photoIsmet Kocaman
      Member

      Text1: Format( [Start], “\Qq” )

    • 05/08/2015 at 8:13 am #339611
      Avatar photoLarry Christofaro
      Participant

      Jan, Ismet rocks. I was wondering if he would join in with a better idea. Ismet, if I ever have a question on formulas I’ll be sure to ping you…:-)

    • 05/08/2015 at 8:26 am #339620
      Avatar photoIsmet Kocaman
      Member

      Thank you Larry. Your solution is also a good and reliable one, which is, I guess, Int((Month([Start])-1)/3)+1

    • 05/12/2015 at 6:25 pm #342907
      Jan Whitehead
      Guest

      Thanks for the formula…it works great! I have another question now. If I have created a custom enterprise project field that is titled “go live actual date” is there anyway to insert this into the formula? I have tried importing the enterprise field into the schedule I am working on and when I start to edit the formula it does not give me the option to select the enterprise project field. Any suggestions? Thanks!

    • 05/12/2015 at 9:31 pm #343008
      Avatar photoLarry Christofaro
      Participant

      Jan, yes you can use an enterprise custom field into any formula just like any other field. Just use the same brackets [field] as you would a project custom field. You can also access the enterprise custom field from within the formula by selecting Insert/Field/type(like text) / Enterprise Custom type(like text). Hope that helps…

    • 05/13/2015 at 10:17 am #343326
      Jan Whitehead
      Guest

      so is this what the formula should look like? Int((Month([Insert/Field/type(Go Live Actual Date)/Enterprise Custom type(Go Live Actual Date)])-1)/3)+1
      My enterprise custom project field is “Go Live Actual Date”

      Thanks!

    • 05/13/2015 at 10:35 am #343335
      Avatar photoLarry Christofaro
      Participant

      Sorry Jan, I tried to follow the steps for inserting the field into the formula (way too much information). The formula would be:
      Int((Month([Go Live Actual Date])-1)/3)+1
      Let us know if that doesn’t work. Thanks…

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