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
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.