How to use a Salesforce Formula Field to display a Quarter value based on the created date?

Want to display a Quarter value based on the created date like below,
from April to Jun – Quarter 1
from July to Sep – Quarter 2
from Oct to Dec – Quarter 3
from Jan to Mar – Quarter 4
For Example,
if one recored is created today i.e :- 25-03-2013
based on above condition the Quarter value is display like “4”
Technical Solution:
Create a formula field under the respective objects and choose the Formula Return Type as a Number.

CASE( MONTH(DATEVALUE( CreatedDate ) )  ,
4, 1,
5, 1,
6, 1,
7, 2,
8, 2,
9, 2,

Written by 

I am Sakthivel Madesh, a certified Salesforce Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 13x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply