Date fields are merged incorrectly when I use an Excel data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jemdlee - 29 May 2007 12:43 GMT

I have date fields formatted in the Australian format - dd/mm/yy, but when I
merge them into Word, they appear as mm/dd/yy.
The field I have in my Word document is "<<Date_1>>"
What do I type in to make the format come out the way I want it?

Reply to this Message

Doug Robbins - Word MVP - 29 May 2007 14:31 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have date fields formatted in the Australian format - dd/mm/yy, but when
>I
> merge them into Word, they appear as mm/dd/yy.
> The field I have in my Word document is "<<Date_1>>"
> What do I type in to make the format come out the way I want it?

Reply to this Message

Jemdlee - 30 May 2007 09:38 GMT

Sorry, that didn't work, or I'm confused.
The example says:
{ Mergefield Date \@ "dd-MMM-yyyy"} - so I would understand that I would
need to substitute "Mergefield" with my merge field (that which is
highlighted in gray) - which is "<<Date_1>>" - I tried that and it didn't
work.
Can you please show me the finished product of what it should look like with
my merge field, not just an example? I then might be able to grasp
understanding of this.

Thanks,

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 7 lines]
> > The field I have in my Word document is "<<Date_1>>"
> > What do I type in to make the format come out the way I want it?

Reply to this Message

Graham Mayor - 30 May 2007 10:45 GMT

You're confused!
You do one or the other, not both
either enter the field manually using CTRL+F9 for the field boundaries
or toggle the inserted field (ALT+F9) and modify that.

The finished result would be
{ Mergefield Date_1 \@ "dd-MMM-yyyy"}

See if http://www.gmayor.com/formatting_word_fields.htm helps

Signature

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

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

> Sorry, that didn't work, or I'm confused.
> The example says:
[quoted text clipped - 27 lines]
>>> The field I have in my Word document is "<<Date_1>>"
>>> What do I type in to make the format come out the way I want it?

Reply to this Message

Jemdlee - 30 May 2007 12:56 GMT

Thanks heaps guys!
Through your efforts in helping me, you have played a valuable role in
affecting the lives of hundreds of kids for the better.
God bless heaps,

Jem

> You're confused!
> You do one or the other, not both
[quoted text clipped - 37 lines]
> >>> The field I have in my Word document is "<<Date_1>>"
> >>> What do I type in to make the format come out the way I want it?

Reply to this Message

Rate this thread: