+ Start a Discussion
sudhirn@merunetworks.comsudhirn@merunetworks.com 

Know Quater and Year based on a date

Hi, 

 I wrote below formula to get quater of based on the date I want to dispaly even the year of the quater please suggest me how to add the year in the formula field. 
CASE(MONTH(DATEVALUE( Logo_Since__c ) ),
1, "Q1",
2, "Q1",
3, "Q1", 
4, "Q2", 
5, "Q2", 
6, "Q2",
7, "Q3",
8, "Q3",
9, "Q3",
10,"Q4",
11,"Q4",
12,"Q4",
"")

Thanks
Sudhir
Best Answer chosen by sudhirn@merunetworks.com
sudhirn@merunetworks.comsudhirn@merunetworks.com
I was able to fix this issue with code below. 
CASE(MONTH( TODAY() ), 
1, "Q1" + "/" + TEXT(YEAR( TODAY() )), 
2, "Q1" + "/" + TEXT(YEAR( TODAY() )), 
3, "Q1" + "/" + TEXT(YEAR( TODAY() )), 
4, "Q2" + "/" + TEXT(YEAR( TODAY() )), 
5, "Q2" + "/" + TEXT(YEAR( TODAY() )), 
6, "Q2" + "/" + TEXT(YEAR( TODAY() )), 
7, "Q3" + "/" + TEXT(YEAR( TODAY() )), 
8, "Q3" + "/" + TEXT(YEAR( TODAY() )), 
9, "Q3" + "/" + TEXT(YEAR( TODAY() )), 
10,"Q4" + "/" + TEXT(YEAR( TODAY() )), 
11,"Q4" + "/" + TEXT(YEAR( TODAY() )), 
12,"Q4" + "/" + TEXT(YEAR( TODAY() )), 
"")

Thanks
Sudhir