Brian Dunning's FileMaker Custom Functions

EDATE ( evalDate ; months )

Replicates the EDATE function from Excel

  Average rating: 4.7 (32 votes) Log in to vote

Jorge Kluchnik   Jorge Kluchnik

Share on Facebook Share on Twitter

  Sample input:
EDATE ( 1/15/2012 , 1 )

EDATE ( 1/31/2012 , 1
  Sample output:
2/15/2012

2/29/2012

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

Replicates the Excel function EDATE. Evaluates the same day in the month of the evalDate, plus x months. If day surpases the last day in target month, then defaults to last day in target month.

 

Comments

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.

Under construction. Email me your wish list for improvements.