Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Dates coyotem78 Mailmerge 3 August 4th 06 09:21 PM
UK dates lose format with Mail Merge DGEB Mailmerge 2 July 20th 06 10:56 PM
Mail Merge and dates Jsampson Microsoft Word Help 3 May 3rd 06 03:52 PM
How do I compare later/earlier dates in a mail merge IF field? AdamT Mailmerge 0 March 13th 06 04:06 PM
Using If Then and Else with dates in a mail merge macropod Mailmerge 1 March 28th 05 11:29 PM


All times are GMT +1. The time now is 12:22 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"