Formula from date to quarter
Please HELP!! I've been trying to figure this out for days! I'm trying to create a formula that will display quarter names (Quarter 1, Quarter 2, Quarter 3, Quarter 4) based on two fields [Meeting Ty...
Forum Discussion
You'll want to use the Month() function in formulas to get the number value of the month itself and then compare to the quarter end - like so
If(
Month([Meeting Date])<=3,"Q2",
Month([Meeting Date])<=6,"Q3",
Month([Meeting Date])<=9,"Q4",
Month([Meeting Date])<=12,"Q1",
"")
You can use <= to check for the non quarter end months like 2 this way
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
If(
Month([Meeting Date])<=3,"Q2",
Month([Meeting Date])<=6,"Q3",
Month([Meeting Date])<=9,"Q4",
Month([Meeting Date])<=12,"Q1",
"")
You can use <= to check for the non quarter end months like 2 this way
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
Perfect! Thank you!!