MonthEnd ( StartDate ; Months )

Returns the date of the last day of the month the specified number of months from the StartDate

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

Josh Ormond - Show more from this author
Iozax, LLC
http://iozax.com

Sample input:

1. MonthEnd ( "12/10/2011" ; 0 )
2. MonthEnd ( "12/10/2011" ; 1 )
3. MonthEnd ( "12/10/2011" ; 2 )

Sample output:

1. 12/31/2011
2. 1/31/2012
3. 2/29/2012

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

/*

MonthEnd ( StartDate ; Months )
Purpose:    Returns the date of the last day of the month the specified number of months from the StartDate.
Author:    Josh Ormond

*/

Date ( Month ( StartDate ) + ( Months + 1 ) ; 0 ; Year ( StartDate ) )

// ===================================
/*

This function is published on BrianDunning.com to check for updates and provide feedback and bug reports please visit:
http://www.briandunning.com/filemaker-custom-functions/detail.php?fn_id=1305


Function: MonthEnd( StartDate; Months )
Author: Josh Ormond
Last updated: 18 May 2011
Version: 1.1

*/
// ===================================

Returns the date of the last day of the month the specified number of months from the StartDate. Enter 0 to get the end of the current month.

Comments

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

MonthEnd ( StartDate ; Months )

Comments

Support this website.

Support this website.