+ Start a Discussion
Karen HallsmanKaren Hallsman 

How can I create a formula field to pull the month from another date field?

We have a field "Renewal Date" which would read as say, 1/1/2016. I want to create a formula field that pulls the month out of that - preferably as the name of the month, so in the example "Jan" or "January". 
Best Answer chosen by Karen Hallsman
SalesFORCE_enFORCErSalesFORCE_enFORCEr
Use this:
CASE(MONTH(Renewal_Date__c),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6,'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec','null')

All Answers

SoleesSolees
You will need to create a text formula field, then use the MONTH(Date field) operator, and then CASE() operator so if you have a 1 then return a 'JAN' or 'JANUARY'.  Do this for all months number cases.
SalesFORCE_enFORCErSalesFORCE_enFORCEr
Use this:
CASE(MONTH(Renewal_Date__c),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6,'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec','null')
This was selected as the best answer
Dilip_VDilip_V
Karen,
Try this.
<strong>CASE(MONTH(<em><span>Renewal_Date__c</span></em>),
1, "January",
2, "February",
3, "March", 
4, "April", 
5, "May", 
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December",
"None")</strong>

Source:
https://dfc-org-production.force.com/forums/ForumsProfile?communityId=09aF00000004HMG&userId=005F0000003FTtC&showHeader=false

Thanks.
Karen HallsmanKaren Hallsman
@ThermoDynamics, this one errored out, but @SalesFORCE_enFORCEr, this worked. Thank you all for your suggestions!