View Single Post
  #4  
Old March 25th, 2010, 12:02 PM posted to microsoft.public.word.mailmerge.fields
Andy Roberts
external usenet poster
 
Posts: 183
Default Specific Date Format

Peter

I have attached the field code i'm using to deal with the Ordinal which is
merging a Merge Field called Date _Received. Everything works ok when it
pulls a date which has an Ordinal of "th" eg 25th, 26th etc. However if it
pulls a date using "rd" "st" or "nd" then I get a syntax error.

The code looks ok to me (but obviously isnt)
--
Regards

Andy

Andy Roberts
Win XP, Office 2007
"Peter Jamieson" wrote in message
...
macropod has an example of this in his Word Date Calculation Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party

(He generally says "Do read the document's introductory material.")

Last time I looked the example was titled

"Insert A Date with Ordinal Numbering"

Peter Jamieson

http://tips.pjmsn.me.uk

On 25/03/2010 08:43, Andy Roberts wrote:
This may not be possible very easily.

I have a sentence in a mail merge doc which reads "Thank you for your
letter
dated 21st August 2009..." with the date being a mail merge field from
Excel.

The format of the mail merge field is {MERGEFIELD Date Required\@"DD MMMM
YYYY"}which gives me 21 August 2010. Is it possible to :-

1. Have the "st" or "th" inserted after the day (i.e 21st or 19th)
2. Have it appear super script like it does if it is typed in word.