Brian Dunning's FileMaker Custom Functions

BiweeklyFrom ( From Date ; After Date )

Calculates the biweekly date based on From Date following After Date

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

Kevin Hayes   Kevin Hayes
KevTools
http://www.kevtools.com

Share on Facebook Share on Twitter

  Sample input:
BiweeklyFrom ( 9/18/2004 ; 10/1/2004 )
  Sample output:
10/2/2004

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

Calculates the next date on or following the "After Date" that falls biweekly from the "From Date". For example, if I get paid biweekly, and I know I got paid on September 04, 2004, the next paycheck following October 1, 2004 will be October 2, 2004.

Note: Calc is more complicated than it would seem to be necessary in order to handle dates that are exactly biweekly increments apart, and "From Dates" that are in the future from "After Dates".

 

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.