Brian Dunning's FileMaker Custom Functions

lastPairedWeekendsInRange ( startDate ; endDate )

Returns a return-separated list of FileMaker-formatted dates representing the last Weekends of each month between the start and end dates where both Saturday and Sunday fall within the same month.

  Be the first to rate this function Log in to vote

Jonni™   Jonni™ - Show more from this author

  Sample input:
lastPairedWeekendsInRange ( Get ( CurrentDate ) ; Get ( CurrentDate ) + 365 )
  Sample output:
28/06/2025
29/06/2025
26/07/2025
27/07/2025
30/08/2025
31/08/2025

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

Generates a list of dates in FileMaker Date format for the last Weekends of each month within a given date range. This function uses recursion to iterate through months, making it compatible with FileMaker versions prior to 18 which do not support the While function.

 

Comments

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 21 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: