function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
PookyPooky 

Birthday month formula

Can anyone help me create a formula that looks at the birthdate and displays a field that just shows the month of the birthday?

 

I have the formual as MONTH( Birthdate__c ) which gives me a number but I prefer the month as text.

 

Thanks!

Message Edited by Pooky on 02-10-2009 03:30 AM
dev_jhdev_jh

There might be a smarter / easier way, but you could accomplish this using CASE

 

CASE(MONTH(DateX), 1, "January", 2, "February", ....)

 

J