Brian Dunning's FileMaker Custom Functions

DayofMonthbyWeek ( DayofWeekWanted_Sunday_1 ; WeekWantedasNum ; MonthasNum ; YearasNum )

Find the weekday of a given month by week, ie: the 3rd Wednesday of the Month

  Average rating: 4.2 (39 votes) Log in to vote

Yvonne Dutreaux   Yvonne Dutreaux
Cordblood Registry

Share on Facebook Share on Twitter

  Sample input:
DayofMonthbyWeek ( 3 ; 3 ; 3 ; 2009 )
  Sample output:
3/17/2009

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

Find the weekday of a given month by week, ie: the 3rd Wednesday of the Month

The day and week are required, but the month and year will auto fill with the current day if not entered.

Good for finding days for meetings that are frequently on monthly basis on a specific day by week basis

 

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.