Last_Saturday ( Date_1 )
Enter a date in the Date_1 field and the calculation will return the last Saturday of that month.
Average rating: 4.1 (33 votes) Log in to vote
Michael Myett - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Enter a date in a date field called Date_1, using the following format, XX/01/XXXX. Create a calculation field using this custom function with the date field as input and it will return the date of the last Saturday in that month.
Apr 12, 2011
|You could use:
Date_1 - Mod ( Date_1 ; 7 ) - 1
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.