Sign Up ›

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

Formula to display a name of the months ?

In Opportunity i have the fields - start date & end date

 

Depending on the fields i want to display names in between the two dates..

 

 please see the screenshot Attached

 

 

 

 

jd123jd123

Hi

 

CASE(MONTH(Start_date__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",
sakthivelsakthivel

Thanks for the reply, if u c my query clearly i want to display the month names from start date to end date.

 

Start date is - jan -

 

End date is - April

 

Resulting Formula will have to show - 

 

January - $$$$

February - $$$$

March - $$$$

April  - $$$$

 

Here is my formula 

 

CASE( MONTH( Start_Date__c ) , 1, "January" +' - '+'$', 
1, "February" +' - '+'$', 
1, "March" +' - '+'$', 
1, "April" +' - '+'$', 
1, "May" +' - '+'$', 
1, "June" +' - '+'$', 
1, "July" +' - '+'$', 
1, "August" +' - '+'$', 
1, "September" +' - '+'$', 
1, "October" +' - '+'$', 
1, "November" +' - '+'$', 
1, "December" +' - '+'$', 
'None') 
+ TEXT(Amount_Monthly_Breakout__c )

 

Please help me to add end date here...