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
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...