Date suffix

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

Karl
Mon Mar 13 18:04:23 CST 2006

Roderick O'Regan wrote:
> 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?

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

(Watch out for wordwrap on that link!)
--
Working without a .NET?
http://classicvb.org/

Jay
Mon Mar 13 19:23:47 CST 2006

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.

On Mon, 13 Mar 2006 23:49:39 +0000, Roderick O'Regan
<rory@removethis.theoregans.com> wrote:

>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

Graham
Tue Mar 14 01:07:55 CST 2006

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

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

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

Jay Freedman wrote:
> 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.
>
>
>> 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

Roderick
Tue Mar 14 04:44:51 CST 2006

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

On Tue, 14 Mar 2006 09:07:55 +0200, "Graham Mayor" <gmayor@mvps.org>
wrote:

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