Answered
Adding "th", "nd", "rd" or "st" to dates
Hi All,
Has anyone come across a date formatting function which can add the appropriate "th", "nd", "rd" or "st" to a date?
I've done a fair bit of googling and haven't come across anything which takes into account that not all numbers ending in 1 should have an "st" appended to them (e.g. 11) or for that matter not all numbers ending in 2 should have a "nd" appended to them (e.g. 12) and so on.
Kylie
Has anyone come across a date formatting function which can add the appropriate "th", "nd", "rd" or "st" to a date?
I've done a fair bit of googling and haven't come across anything which takes into account that not all numbers ending in 1 should have an "st" appended to them (e.g. 11) or for that matter not all numbers ending in 2 should have a "nd" appended to them (e.g. 12) and so on.
Kylie
