Custom Function: Get Number Suffix

Posted in Custom Functions

Here is a useful custom function to return the suffix for a day in a month, for example if you pass it 1, it will return st, which you can append to make up a text representation of a date, eg 1st May etc.

Function Name:NumberSuffix
Function Parameters:Number
Function Code

Let( [
special_th = Case(
Mod (Number; 100) = 11 or
Mod (Number; 100) = 12 or
Mod (Number; 100) = 13; 1) ;
end = Mod ( Number ; 10 )
];
Case ( special_th; “th”; end = 1; “st”; end = 2; “nd”; end = 3; “rd”; “th”)
)

Example Input:22
Example Output:nd
Example Usage:$suffix = NumberSuffx(22)

RSS Feed   Trackback URL  Add comment  Edit Page

One Response to “Custom Function: Get Number Suffix”

  1. Mike Scott Says:
    August 12th, 2010 at 7:30 am

    I like it – thanks! I’ve not used custom functions before, so I experimented with your example.

Leave a Reply