Edate ( thedate ; months )

Excel style EDATE function

Average rating: 4.3 (41 votes) Log in to vote

Barry Maskell
Real Estate Navigator
http://www.realestatenavigator.com.au

Sample input:

EDATE ( thedate , 6 )

Where the date is the date field in FMPro database
eg 1/2/2007

Sample output:

1/8/2007

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Numerator / Denominator
/* This function tries to imitate the EDATE function in EXCEL to allow easy conversion of EXCEL code to FMPro

*/

Let([

thedate = GetAsDate ( thedate );
months = GetAsNumber(months)

];

     Date ( Month (thedate ) + months; Day ( thedate ); Year ( thedate ))

)

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.

Comments

		Jorge, Liechtenstein 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.

Edate ( thedate ; months )

Comments

Support this website.

Support this website.