IncDateOneMonth ( StartDate ; LastDate )

Increments a Date field one month based on a starting date

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

Don Wieland - Show more from this author
DW Data Concepts
http://www.dwdataconcepts.com

Sample input:

IndDateOneMonth ( 1/31/2007 , 1/31/2007 )

IndDateOneMonth ( 1/30/2007 , 2/28/2007 )

IndDateOneMonth ( 1/31/2007 , 3/31/2007 )

Sample output:

2/28/2007
3/31/2007
4/30/2007

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

Case(

Day ( StartDate ) ≠ Day ( Date ( Month ( LastDate )  + 1; Day ( StartDate ) ; Year ( LastDate ) ) );  

Date ( Month ( LastDate )  + 2; 1 ; Year ( LastDate ) ) - 1; 
Date ( Month ( LastDate )  + 1; Day ( StartDate ) ; Year ( LastDate ) ))

Increments month of a date field except when the days of the next month are less than the DAY of the start date in which the last day is returned.

Comments

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

IncDateOneMonth ( StartDate ; LastDate )

Comments

Support this website.

Support this website.