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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.