Add Ordinal Suffix (st, nd, rd, th) to date

[devgp]

Hello!

In Open Office 4.0.1 on Windows 7 32bit I'm inserting a date using a field:

Code: Select all

Insert | Fields | Other .... Date / Date Fixed / Additional Formats / Format code: D MMMM YYYY

This gives me: 10 November 2013

However I need the ordinal suffix: 10th November 2013

What's the correct code to use to add the ordinal suffix (st, nd, rd, th) into the date?

Many thanks for your help!

[acknak]

Greetings and welcome to the community forum!

Sorry--as far as I know, there is no support for adding the ordinal suffixes when displaying a date. You can get the suffix formatted (as a superscript) automatically but you have to type the ordinal yourself, 1st, and even that doesn't work in a field.