LastMonday ( themonth ; theyear )

Returns the date for the last Monday in a given month

Average rating: 4.1 (30 votes) Log in to vote

Theo Ros - Show more from this author

Sample input:

LastMonday ( 5 ; 2005 )

Sample output:

May 30, 2005

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

/* ----------------------------------------------------------
Returns the date for the last Monday in month
'themonth' and year 'theyear'

In:  themonth  - integer value 1 to 12 for the month
       theyear - integer value for the year
       if empty, the function uses the current date

Return type: Date
Syntax: LasttMonday ( month ; year )
Uses function FirstMonday()

LastMonday ( 5 ; 2005 )  returns May 30, 2005

Author - Theo Ros
----------------------------------------------------------*/

Let ( [ m = If ( IsEmpty ( themonth ) or themonth < 1 or themonth > 12 ; 
                  Month ( Get ( CurrentDate ) ) ; themonth ) ;
           y = If ( IsEmpty ( theyear ) ; Year ( Get ( CurrentDate ) ) ; theyear ) ;
           nextmonth = Month ( Date ( m + 1 ; 1 ; y ) ) ] ;        // get the next month
  FirstMonday ( nextmonth ; y ) - 7        // get first monday of next month and subtract 7
)

Returns the date for the last Monday in month
'themonth' and year 'theyear'

In: themonth - integer value 1 to 12 for the month
theyear - integer value for the year
if empty, the function uses the current date

Return type: Date

Comments

		Jake DeGroot Jun 8, 2012
This function doesn't work if you select the month december (12) for any year, is there any way to get around the error?

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

LastMonday ( themonth ; theyear )

Comments

Support this website.

Support this website.