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
Hitesh KhannaHitesh Khanna 

I want to create a field that will pick the month from the createdDate field and display it as text. How do i do that ?

Best Answer chosen by Hitesh Khanna
Abdul KhatriAbdul Khatri
You can create a Text Data Type formula field with the following code 
CASE( MONTH( DATEVALUE( CreatedDate)), 1, 'JAN', 2, 'FEB', 3, 'MAR', 4, 'APR', 5, 'MAY', 6, 'JUN', 7, 'JUL', 8, 'AUG', 9, 'SEP', 10, 'OCT', 11, 'NOV', 12, 'DEC','')