BillingDay ( DayOfMonth )
Makes sure the DayOfMonth given is actually a day in the current month.
Average rating: 4.4 (35 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Enter a day of the month, like 30, and the function will return a valid day of the current month.
This handles cases where the current month has fewer days in it than the day of month entered.
Handles leap years.
15 would return 15 in every month
31 would return 31 in December
31 would return 30 in November
30 would return 28 in February
Jan 14, 2009
|Oooh comments and ratings! Love it.|
Brian Dunning, BrianDunning.com
Aug 19, 2018
|Of course. :-)|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.