Loading...
Quick Links

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

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

Tagged: 

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #339043 Reply
    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 Reply
    Larry ChristofaroLarry 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 Reply

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

    #339611 Reply
    Larry ChristofaroLarry 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 Reply

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

    #342907 Reply
    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 Reply
    Larry ChristofaroLarry 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 Reply
    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 Reply
    Larry ChristofaroLarry 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 9 posts - 1 through 9 (of 9 total)
Reply To: Need formula to convert start date into quarter of the year in a custom field
Your information:




− 1 = 7