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 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 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 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 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: Reply #339611 in Need formula to convert start date into quarter of the year in a custom field
Your information:

55 − = 48