Given any number, this function calculates the suffix. For example 1 calculates
Average rating: 4.6 (31 votes) Log in to vote
Michael Richards - Show more from this author
suffixNumber ( 2 )
suffixNumber ( 3 )
suffixNumber ( 4 )
suffixNumber ( 21 )
suffixNumber ( 22 )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Filemaker provides the ability to customise the formatting and display of a date, time and number. However there is no functionality to calculate a conditional suffix (units); a human readable suffix.
For a given number this custom funtion calculates the human readable suffix; "st", "nd" , "rd" , "th".
It is predominantly used for date related calculations where the day number is displayed with human readable units. For example:
(a) payment is the 1st of every month
(b) fees are due on the 2nd week of every month
(c) 3rd quarter results were up
(d) the 24th is great for us to meet
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.