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
HaralambyHaralamby 

Date Formula Needed

Hello,

 

I am trying to find a formula/function in Salesforce that is the equivalent to the EOMONTH function in excel.  The excel function is as follows:

 

Scenario 1 =EOMONTH(A1,0)  => this gives me the end date of the month that is in cell "A1"

 

Scenario 2 =EOMONTH(A1,1)  = > this give me the end date of 1 month after the month  that is in cell "A1"

 

So if A1 is Jan 15,2009 the function would give me Jan 31, 2009 in scenario 1 and Feb 28, 2009 in scenario 2.

 

Does anyone know how this can be accomplished in Salesforce?

Best Answer chosen by Admin (Salesforce Developers) 
kamlesh_chauhankamlesh_chauhan
see my reply on
http://community.salesforce.com/sforce/board/message?board.id=Visualforce&thread.id=15350

All Answers

Richie DRichie D

This has already been solved - see posting on VisualForce discussion board by same poster.

R. 

kamlesh_chauhankamlesh_chauhan
see my reply on
http://community.salesforce.com/sforce/board/message?board.id=Visualforce&thread.id=15350
This was selected as the best answer