Edate ( thedate ; months )
Excel style EDATE function
Average rating: 4.3 (41 votes) Log in to vote
Real Estate Navigator
Where the date is the date field in FMPro database
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
An excel style EDATE function
Returns the date that is the indicated number of months before or after a specified date (thedate). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
Months is the number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.
Dec 12, 2011
This function does NOT work like EDATE in Excel.
In Excel, putting in EDATE (1/31/2012, 1) would result in 2/29/2012. This function results in 3/2/2012.
It should give the same date as the month it started with, but if the target month does not have that day because it is a shorter month, then it should give the last day of the month.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.