AnsweredAssumed Answered

Change Month Number To Text (1 to JAN, 2 to FEB etc)

Question asked by Philip Scott on Mar 3, 2017
Latest reply on Mar 28, 2017 by Philip Scott

Hello, 

I have created a field that displays the Month an Opportunity Closed. It is coming over as a number but I would like this to be displayed as text i.e. 1 = JAN, 2 = FEB, 3 = MAR etc.

 

The Field I have created is month_closed_c (Text Field) and is using this formula: monthofyear($date_closed)

 

How can I convert the number value this field returns in to a text value?

 

Thanks

Outcomes