EDATE ( evalDate ; months )

Replicates the EDATE function from Excel

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

Jorge Kluchnik - Show more from this author

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)

/*
 * =====================================================
 * EDATE ( evalDate; months )
 * 
 * RETURNS:        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.
 * PARAMS:         Any date, number of months away to evalutate
 * DEPENDENCIES:   none
 * AUTHOR:         Jorge Kluchnik
 * NOTES:
 * =====================================================
*/



Let([

~targetDate = Date ( Month ( evalDate ) + months; Day ( evalDate ); Year ( evalDate ) ) ;
~EOM = Date ( Month ( evalDate ) + 1 + months; 0; Year ( evalDate ) )

];

Min (~targetDate ; ~EOM )

)

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

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

EDATE ( evalDate ; months )

Comments

Support this website.

Support this website.