Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

numbers "st" "nd" "rd" "th"

0 views
Skip to first unread message

Eric Crimmins

unread,
Jan 2, 2000, 3:00:00 AM1/2/00
to
I am doing a mailmerge to Word, which prints peoples birthdays

I can get dates lioke "1 December" and "28 February", but how do I get the
"st", "nd", "rd", "th" etc

Can anyone help ?

Eric

Michel Walsh

unread,
Jan 3, 2000, 3:00:00 AM1/3/00
to
Hi,


something like:

? Nz(Choose(1+Day(Date()) Mod 10, "th", "st", "nd", "rd"), "th")


or, more precisely:
Day(Date()) & Nz(Choose(1+Day(Date()) Mod 10, "th", "st", "nd", "rd"), "th")
& _
" " & Format(Date(), "mmm")


assuming, for sure, that your regional setting is in English (to get the
month name).


Hoping it may help,
Vanderghast, Access MVP.

Eric Crimmins <er...@finsoft.demon.co.uk> wrote in message
news:946855202.21235.0...@news.demon.co.uk...

0 new messages