Brian Dunning's FileMaker Custom Functions

IncrementDate ( StartDate ; Frequency )

Returns a date incrementally later than StartDate.

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

Kevin Bache   Kevin Bache
None
www.none.com

Share on Facebook Share on Twitter

  Sample input:
IncrementDate ( "7/31/07" ; "Monthly" )

IncrementDate ( "8/31/07" ; "Monthly" )

IncrementDate ( "11/29/07" ; "Semi-Monthly" )

IncrementDate ( Get ( CurrentDate ) ; "Quarterly" )
  Sample output:
8/31/2007


9/30/2007


12/15/2007


2/7/2008

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

Simple function that returns a date incrementally later than StartDate.

Accepted increments are:
Weekly
Bi-Weekly
Semi-Monthly
Monthly
Bi-Monthly
Quarterly
Semi-Annually
Annually
Bi-Annually

 

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.