ordinal

Use the ordinal function to convert a number into the corresponding ordinal. The output is localized based on the current output language.

ordinal ( input )

This function returns a value of type TEXT.

The function has one parameter:

• input, type NUMBER. The number to be converted.

This function only supports values between 0 and 100, inclusive. Fractional parts are ignored.

The output for values outside the supported range is undefined.

Examples

ordinal (1) results in "first"

ordinal (1) results in "eerste" (output language NLD)