Brian Dunning's FileMaker Custom Functions

NthWeekday_CurrentMonth ( theweekday ; occurrence )

Returns the Nth Weekday of the Current Month

  Average rating: 4.3 (14 votes) Log in to vote

Jeep Watson   Jeep Watson
Jeep Watson
www.

Share on Facebook Share on Twitter

  Sample input:
NthWeekday_CurrentMonth ( 3 ; 2 )
  Sample output:
08/09/2016

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

I use this in a Bill Paying App to show the Social Security deposit day for the current month. It could be used for any recurring monthly event. I have used a variant of the function in an app to return the date for any day, given a Month, Year and Occurrence. Another variant creates a PDF of the year's recurring event for printing schedules.

 

Comments

M   M, FL
Dec 29, 2017
Can you please explain this and the steps better... do I copy and paste this into the calculation field as is? When I do I get an error (the specified field "theweekday" can not be found).

I don't understand the format of the input or where to create and how to pass that info :-(

Still new and all this... seems so complex just to get a list of 2nd fridays in a given year :-(
 

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.