function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
WPCMSWPCMS 

Formula: Turn Date into Month Only

I need to take a date field and create a new field that reads the month only. If the date was 11/05/2008 I need the custom field to say "November" or if says 03/09/01 I need the field to say "March". The year is irrelevant. How would I do that?

 

Thank you in advance.

Best Answer chosen by Admin (Salesforce Developers) 
CaptainObviousCaptainObvious

Try this:

 

CASE(Month( Date_Field__c ),1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December","")
 
Date_Field__c is your custom Date field (It won't work if it's a Date/Time Field).


All Answers
mpannmpann
MONTH (date__c) will give you the month of the custom field date. You would use it in a formula (text) field.


tstrongtstrong
Use a formula field and the  MONTH(date) function.


CaptainObviousCaptainObvious
Try this:
 
CASE(Month( Date_Field__c ),1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December","")
 
Date_Field__c is your custom Date field (It won't work if it's a Date/Time Field).
This was selected as the best answer