ShowAll Questionssorted byDate Posted
sudhirn@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
sudhirn@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