Brian Dunning's FileMaker Custom Functions

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   Brian Dunning
BrianDunning.com
https://www.briandunning.com

Share on Facebook Share on Twitter

  Sample input:
DayOfMonth ( 31 )
  Sample output:
30

  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

 

Comments

Peter Vinogradov   Peter Vinogradov
Jan 14, 2009
Oooh comments and ratings! Love it.
 
Brian Dunning   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.

Under construction. Email me your wish list for improvements.