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?
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.
Text1: Format( [Start], “\Qq” )
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…:-)
Thank you Larry. Your solution is also a good and reliable one, which is, I guess, Int((Month([Start])-1)/3)+1
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!
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…
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”
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…