View Single Post
  #27  
Old February 15th, 2008, 07:03 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Using dates during mail merge

You are welcome

--

Graham Mayor - Word MVP

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



gjupp via OfficeKB.com wrote:
Yes, this works fine, and I think that I (just about) understand HOW
it works. So now I have 2 solutions to my orignal query. Gentlemen,
many thanks indeed for sparing the time to sort this out. We now have
a 'system' that is comfortable to use and more than adequately meets
our needs. It's just great


Graham Mayor wrote:
The OP did say earlier in the thread that he was using UK pattern
dates.

Just to clarify my original suggestion using the field name that was
adopted earlier in the thread, and restoring the missing quote

{ ASK MyDate "Start Date" \d { Date \@ "dd/MM/yyyy"} \o }{ SKIPIF {
MERGEFIELD DateField } "{ REF MyDate \@ "d " \*Ordinal}{ REF
MyDate \@ " MMMM
yyyy" }" }

This should work provided (as Peter indicated) {Mergefield DateField}
produces a date in the exact format
1st January 2008
ie 1[space]st[space]January[space]2008
If there is no space between 1 and st, change

{ REF MyDate \@ "d " \*Ordinal}
to
{REF MyDate \@ "d" \*Ordinal}

If you have some other format but January eg january or JANUARY you
will need more formatting switches. The match must be a true match.
http://www.gmayor.com/formatting_word_fields.htm

Well, I suppose saying in "theory" is not quite right either given
that there is no formal specification of the field language or its

[quoted text clipped - 99 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200802/1