Brian Dunning's FileMaker Custom Functions

MonthsAhead ( StartDate ; Months )

Finds a future date by number of months ahead, correcting for months with differing numbers of days.

  Average rating: 4.5 (29 votes) Log in to vote

Geoff Coffey   Geoff Coffey

Share on Facebook Share on Twitter

  Sample input:
MonthsAhead ( "1/31/2005" ; 3)
  Sample output:
4/30/2005

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

Months Ahead has a function that is kind of hard to explain. Imagine you have a rental situation, and you intend to bill monthly. Figuring out what date to bill each month is easy in most cases, but when the start date is near the end of the month, it can be tough. Often you want a rental that starts on Jan 31 to be billed on Feb 28, March 31, and April 30. You can get this effect using the MonthsAhead function.

 

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.