Brian Dunning's FileMaker Custom Functions

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   Josh Ormond
n/a
http://fmrift.wordpress.com

Share on Facebook Share on Twitter

  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)

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

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.