Date suffix

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roderick O'Regan - 14 Mar 2006 00:49 GMT

I would like to create a template for a user who wants to use dates in
the format '13th March 2006' for example.

Normally, as far as dates are concerned, I might insert a CreateDate
field to show the date a letter was created. This might show as '22
February 2006' format

However, in this case I have to try and use the same type of field but
with the suffix 'st', 'nd', and so on after the appropriate number.

Is there any way, please, that this can be done with a field or with
VBA? Or do they have to type the date in manually to achieve this
format?

Regards

Roderick

Reply to this Message

Karl E. Peterson - 14 Mar 2006 01:04 GMT

> I would like to create a template for a user who wants to use dates in
> the format '13th March 2006' for example.
[quoted text clipped - 9 lines]
> VBA? Or do they have to type the date in manually to achieve this
> format?

http://groups.google.com/group/microsoft.public.vb.syntax/browse_thread/thread/1
95b232ae581e13/b6691e3b0edf9d31?lnk=st&q=date+suffix+vb&rnum=1#b6691e3b0edf9d31

(Watch out for wordwrap on that link!)

Signature

Working without a .NET?
http://classicvb.org/

Reply to this Message

Jay Freedman - 14 Mar 2006 02:23 GMT

Create the following pair of fields, select them together, and make an
AutoText or AutoCorrect entry from them:

{Date \@"dd" \*ordinal} {Date \@"MMMM yyyy"}

The first field displays the day number with the suffix, and the
second field shows the month and year.

You can substitute any of the other "date" field types, such as
CreateDate.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

>I would like to create a template for a user who wants to use dates in
>the format '13th March 2006' for example.
[quoted text clipped - 13 lines]
>
>Roderick

Reply to this Message

Graham Mayor - 14 Mar 2006 08:07 GMT

It's a little more complicated if you want the ordinal superscripted - see
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Create the following pair of fields, select them together, and make an
> AutoText or AutoCorrect entry from them:
[quoted text clipped - 25 lines]
>>
>> Roderick

Reply to this Message

Roderick O'Regan - 14 Mar 2006 11:44 GMT

Thanks to all three of you for your help.

It took me a couple of minutes to resolve the challenge and then about
an hour just reading the masses of information which came out of it.
Did I learn something here!

Roderick

>It's a little more complicated if you want the ordinal superscripted - see
>http://www.gmayor.com/formatting_word_fields.htm

Reply to this Message