Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mr. WMr. W 

Formula Date Field: "Month/Year"

Sorry if this is a simple one, but can you create a formula date field taht displays: "Month/Year"

 

From an existing standard date field, I would like to create a formula that pulls just the "MONTH/YEAR"

 

Tthe solution cannot be convert the DATE field to a TEXTas that creates issues in reports when sorting.   

 

Thanks! 

arizonaarizona

One thing you can do is YEAR/MONTH.  Then you can convert to text and sort appropriately.

 

 
Raj.ax1558Raj.ax1558

Yes it is possible, But you need use some technique-

 

Step 1) Create a temperory forumula field, that is type 'Date' and in this use Today() as forumula.

         Formula-                         Today()

         Type -                               Date

         Assume name is -        rajjha_tempdate__c

 

Step 2) Create a another forumula field, this is type 'Text' and write this formula -

          LEFT(TEXT(rajjha__tempdate__c),   LEN(TEXT(rajjha__tempdate__c))-3)

 

now insert a new record, surely you will get Month-Year  value.

 

 

NOTE: mark this as solution for others to get it easily

 

 

 
Mr. WMr. W

That would give me the formula, but since it is not in a Date formate, when it is grouped in a report it will not be in chronological order. 

 

Do you know how to accomplish that?
arizonaarizona

My bad.  You could save it as a number though as 2012.01, 2012.02 ... 2012.12
Raj.ax1558Raj.ax1558

Try to convert final text into Date. May be on a same formula field or you need another formula field. 

eg. 

Date(textformulafield__c);

 

If you not find solution please reply I wil give you another solution

 

Thank You.
Mr. WMr. W

Thanks for your suggestion however it still doesnt' work. 

 

Error: Incorrect number of parameters for function 'DATE()'. Expected 3, received 1

 

 

Any suggestions?

 

Many thanks!