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

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

Tagged: 

Viewing 8 reply threads
  • Author
    Posts
    • #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?

    • #339269
      Larry 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.

    • #339584

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

    • #339611
      Larry 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…:-)

    • #339620

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

    • #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!

    • #343008
      Larry 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…

    • #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!

    • #343335
      Larry 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…

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