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