Date suffix

R

Roderick O'Regan

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
 
K

Karl E. Peterson

Roderick said:
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/micr...k=st&q=date+suffix+vb&rnum=1#b6691e3b0edf9d31

(Watch out for wordwrap on that link!)
 
J

Jay Freedman

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
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 
R

Roderick O'Regan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top