Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

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

Brian Dunning - Show more from this author BrianDunning.com https://www.briandunning.com

  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. Examples: 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 */ Let ( LastDay = Day ( Date ( Month ( Get ( CurrentDate ) ) + 1 ; 1 ; Year ( Get ( CurrentDate ) ) ) - 1 ) ; If ( LastDay < DayOfMonth ; LastDay ; DayOfMonth ) ) Click to copy

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.

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

 

Comments

		Peter Vinogradov Jan 14, 2009
Oooh comments and ratings! Love it.

		Brian Dunning, BrianDunning.com Aug 19, 2018
Of course. :-)

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: