Brian Dunning's FileMaker Custom Functions

FindNextWeekday ( startDate ; dayofweeknumber )

Finds the next or previous week date from starting date

  Be the first to rate this function Log in to vote

Rob Poelking   Rob Poelking
Excelisys, Inc.
http://excelisys.com

Share on Facebook Share on Twitter

  Sample input:
FindNextWeekday ( Date ( 11 ; 6 ; 2018 ) ; -1 )
  Sample output:
11/4/2018

  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.

 

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.