Brian Dunning's FileMaker Custom Functions

Edate ( thedate ; months )

Excel style EDATE function

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

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

Share on Facebook Share on Twitter

  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)

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   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.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: