FindNextWeekday ( startDate ; dayofweeknumber )
Finds the next or previous week date from starting date
Be the first to rate this function Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
with a given start date, calculates the date of the provided DayOfWeek
for example. FindNextWeekday ( Date ( 9 ; 7 ; 2016) ; 5 ) returns Thursday, 9/8/2016
Day of week is specified numerically from 1-7 starting from Sunday. Specifying
a negative day of week will return the previous date. FindNextWeekday ( Date ( 11 ; 6 ; 2018 ) ; -1 ) returns Sunday 11/4/2108.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.