NthWeekday_CurrentMonth ( theweekday ; occurrence )
Returns the Nth Weekday of the Current Month
Average rating: 4.3 (14 votes) Log in to vote
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.
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 :-(
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.