DateAsNthWeekdayOfMonth ( date )

Returns date formatted as "Nth DayName of MonthName".

  Average rating: 4.5 (24 votes) Log in to vote

Michael Horak - Show more from this author *COMMENT Visual Realisation

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

Converts date to a string containing the name of the month, the name of the weekday and the ordinal number of the occurrence of the weekday in the month.

This function is NOT recursive.

Comments

		Lee Smith Apr 2, 2015
The Parameters of “date” will not allow the CF to work. I changed it to “adate" in al of the pertinent places and it works like a charm.

		comment, VR Apr 2, 2015
@Lee > The Parameters of “date” will not allow the CF to work. I am well aware of that. See the discussion here: http://www.briandunning.com/cf/1602

		Carl Rhoades, Clinton Twp MI Apr 28, 2015
I am tryint to find the oposite of this function. Such that I can enter from a couple of fields the "WeekOfTheMonth" eg 1,2,3,4,5 and "DayOfWeek" eg mon, tue, wed, and so on (or a number 1-7). which would then calculate a date in the upcoming month this would help for meeting dates like the 3rd tue of each month or for a next scheduled monthly service call that is always on the 2nd wed of each month

		comment, VR Apr 28, 2015
@Carl This is not a good place to post your question. Why don't you join a forum?

		Carl Rhoades, Clinton Twp MI Apr 29, 2015
Sorry, just thought you might have some insight since you defined it perfectly the other way around. FileMaker does all kinds of wonderful date function things if you give it a date but I find no way to start with some non date parameters and come up with a date. Thanks

		Jeep Watson, Baltimore May 28, 2015
@Carl Here's a dropbox link to a file that might be what you're looking for: https://www.dropbox.com/s/9klj4w1x0vof45v/Every%20Nth%20Weekday.fp7?dl=0

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: