SetDueDate ( StartDate ; DueDay ; Occ ; Freq )

Set due dates according to Frequency, occurences and Month's day defined

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

Romain Dunand - Show more from this author
1-more-thing
http://www.1-more-thing.com

Sample input:

SetDueDate ( "02/19/2008" ; 31 ; 1 ; 1 )

SetDueDate ( "02/19/2008" ; 31 ; 4 ; 1 )

Sample output:

02/29/2008

05/31/2008

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

Let([
_Occ = Case( Day( StartDate ) < DueDay ; Occ-1; Occ );
_Month = Month( StartDate )+( _Occ * Freq );
_MonthLastDay = Day( Date( _Month + 1 ; 0 ; Year( StartDate )));
_Day = Case( _MonthLastDay < DueDay ; _MonthLastDay ; DueDay );

_r = Date( _Month; _Day; Year( StartDate ))

];
_r
)

Set the next due date according to frequency, Occurrence and month's day defined

Comments

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

SetDueDate ( StartDate ; DueDay ; Occ ; Freq )

Comments

Support this website.

Support this website.