You need to sign in to do that
Don't have an account?

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?
http://community.salesforce.com/sforce/board/message?board.id=Visualforce&thread.id=15350
All Answers
This has already been solved - see posting on VisualForce discussion board by same poster.
R.
http://community.salesforce.com/sforce/board/message?board.id=Visualforce&thread.id=15350