LastSaturdaysInRange ( startDate ; endDate )

Returns a return-separated list of FileMaker-formatted dates representing the last Saturday of each month between the start and end dates.

Be the first to rate this function Log in to vote

Jonni™ - Show more from this author

Sample input:

LastSaturdaysInRange ( Get ( CurrentDate ) ; Get ( CurrentDate ) + 365 )

Sample output:

3/30/2024¶4/27/2024¶5/25/2024...

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

// LAST SATURDAYS IN RANGE

// Returns a return-separated list of FileMaker-formatted dates representing 
// the last Saturday of each month between the start and end dates.

// Function Name : LastSaturdaysInRange
// Parameters : startDate ; endDate
// Use example : LastSaturdaysInRange ( Get ( CurrentDate ) ; Get ( CurrentDate ) + 365 )

Let ( [
    y = Year ( startDate ) ;
    m = Month ( startDate ) ;
    firstOfMonth = Date ( m ; 1 ; y ) ;
    lastOfMonth = Date ( m + 1 ; 0 ; y ) ;
    lastDow = DayOfWeek ( lastOfMonth ) ;
    lastSaturday = lastOfMonth - Mod ( lastDow ; 7 ) ;
    nextMonth = Date ( m + 1 ; 1 ; y )
];
    If (
        firstOfMonth > endDate ;
        "" ;
        lastSaturday & ¶ & 
        LastSaturdaysInRange ( nextMonth ; endDate )
    )
)

// Generates a list of dates in FileMaker Date format for the last Saturday 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.

// GitHub : https://github.com/roxytheman/fmCustomFunctions/blob/b504170786ef2d53ee52c1c294a0022e6178ed18/functions/LastSaturdaysInRange.fmfn
// BD Link : https://www.briandunning.com/cf/2802
// Written by: jonni@me.com
// V 1.0

Generates a list of dates in FileMaker Date format for the last Saturday 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

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

LastSaturdaysInRange ( startDate ; endDate )

Comments

Support this website.

Support this website.