Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

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 www.

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

// Function: NthWeekday_CurrentMonth ( theweekday ; occurrence ) // Parameter: theweekday (1=Sun, 2=Mon, 3=Tue, 4=Wed, 5=Thu, 6=Fri, 7=Sat) // Parameter: occurrence (which occurrence in the month -- 1 to 4 only) // Returns the Nth Weekday of the Current Month // Example: 2nd Tuesday of August, 2016 // NthWeekday_CurrentMonth ( 3 ; 2 ) = 08/09/2016 // Example: 4th Friday of August, 2016 // NthWeekday_CurrentMonth ( 6 ; 4 ) = 08/26/2016 Let ( [ m = Month ( Get ( CurrentDate ) ) ; y = Year ( Get ( CurrentDate ) ) ; d = Mod ( theweekday - DayOfWeek ( Date ( m ; 1 ; y ) ) + 7 ; 7 ) + 1 ; o = Case ( occurrence = 1 ; 0 ; occurrence = 2 ; 7 ; occurrence = 3 ; 14 ; occurrence = 4 ; 21 ; "1 to 4 only" ) ] ; Date ( m ; d ; y ) + o ) Click to copy

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, 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 20 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: