Ask Your Question
0

How to get date ordinals in date format

asked 2017-10-05 12:42:50 +0100

EoghanM gravatar image

I'm using the following date format:

 D MMMM YYYY

To display today's date: 5 October 2017

I can do the following to add the ordinal:

 D\th MMMM YYYY

5th October 2017

But obviously this won't work correctly for e.g. 1st October 2017

Is there a way?

edit retag flag offensive close merge delete

Comments

No, I hope.
However, if there is one it will heavily depend on the locale, and as far as I can tell the many 'English (somehing)' locales may act differently. In the UK itself it is uncommon to use an ordinal mark in written dates. There may be thousands of excessively stubborn ways to write dates in the English speaking world.
Your D\th MMMM YYYY does not work for me with UI=locale=DocLanguage= English (UK). The h is taken for "hour".

Lupp gravatar imageLupp ( 2017-10-05 15:29:51 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2020-09-19 18:28:58 +0100

Olivier gravatar image

Should be

[NatNum12 D=ordinal-number]D" of "MMMM "of" YYYY
edit flag offensive delete link more
0

answered 2017-10-05 19:36:12 +0100

Jim K gravatar image

updated 2017-10-05 19:39:12 +0100

Adapted from https://akntechblog.wordpress.com/201...

=DAY(TODAY())&IF(OR(DAY(TODAY())={1;2;3;21;22;23;31}); CHOOSE(1*RIGHT(DAY(TODAY());1);"st";"nd ";"rd ");"th ") &TEXT(TODAY();"mmmm yyyy")

See also @Lupp's answer at https://ask.libreoffice.org/en/questi...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-05 12:42:50 +0100

Seen: 542 times

Last updated: Sep 19 '20