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

Sample input:

MonthsAhead ( "1/31/2005" ; 3)

Sample output:

4/30/2005

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

Let(
   [guess = Date(Month(startDate) + months; Day(startDate); Year(startDate));
   expectedMonth = Mod(Month(startDate) + months - 1; 12) + 1];

   If ( Month(guess) = expectedMonth; guess; Date(Month(startDate) + months + 1; 1; Year(startDate)) - 1 )
)

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

		Pedro Gallego, Alien Solutions Consultants Jan 11, 2019
Thanks a lot for that, it really helped.

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

MonthsAhead ( StartDate ; Months )

Comments

Support this website.

Support this website.