Brian Dunning's FileMaker Custom Functions

numOrdinalSuffix ( number )

Returns the appropriate ordinal number suffix (-st, -nd, -rd, -th) for a supplied number. Thus, 12 would return a superscript

  Average rating: 4.6 (37 votes) Log in to vote

Jonathan Mickelson   Jonathan Mickelson - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
numOrdinalSuffix ( 12 )
numOrdinalSuffix ( 1 )
numOrdinalSuffix ( 23 )
numOrdinalSuffix ( 892 )

numField & numOrdinalSuffix ( numField )

  Sample output:
th (as in 12th)
st (as in 1st)
rd (as in 33rd)
nd (as in 892nd)


  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Returns the correct ordinal suffix (-st, -nd, -rd, -th) for a given number. For example if a supplied parameter "number" is 12, the result is "th". This uses the English ordinal numbering rules for all numbers. Thus, normal use of the function to display the number followed by the Ordinal suffix would use a similar calculation to the following:

numberField & numOrdinalSuffix ( numberField )

Result Type - text (with optional Superscript style ordinal, enabled by default)

Note - To remove the style modification of "Superscript" just remove the value from the variable txtStyle defined below to make it null or "".



Log in to post comments.


Note: these functions are not guaranteed or supported by 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 15 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: