Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / General MS Word Questions / January 2007

Tip: Looking for answers? Try searching our database.

US date format in merge field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michelle - 25 Jan 2007 19:40 GMT
Hello, I am trying to sort out a problem for my sister, we live in the UK,
and her regional settings are configured to display dates as British dates
(dd/mm/yyyy). She is doing a mail merge from an Access table, the table has
some dates in a date/time field (which display correctly in British date
format). The mail merge all works correctly except that when they come into
Word, the dates are switched to US date format (mm/dd/yyyy). Dates normally
display correctly on her machine, and I can't see any way to change it in
this mail-merge.

Any Ideas? Please?
Peter Jamieson - 25 Jan 2007 20:28 GMT
There is a known problem here but only with some versions of Word
a. which version of Word? (can you provide the full version number from the
Help|About box?
b. you may be able to fix the problem using a "date format switch" in your
mail merge main document. Use Alt-F9 to display the underlying field codes
and if your date field is called mydate, Word will have something like

{ MERGEFIELD mydate \*Mergeformat }

type \@"DD/MM/YYYY" in there to give you

{ MERGEFIELD mydate \@"DD/MM/YYYY" \*Mergeformat }

and try again. Make really sure that ambiguous dates such as 05/06/2006 are
coming through the right way round
c. if that does not work, you may be able to work around by checking Word
Tools|Options|General|"Confirm conversion at open", then going through the
connection process again and selecting the DDE option when offered (NB, the
DDE method is obsolescent and doesn't pass through Unicode characters if you
happen to be using them). Again, be sure that ambiguous dates such as
05/06/2006 are coming through the right way round.

Peter Jamieson
> Hello, I am trying to sort out a problem for my sister, we live in the UK,
> and her regional settings are configured to display dates as British dates
[quoted text clipped - 6 lines]
>
> Any Ideas? Please?
Joe Black - 30 Jan 2007 12:19 GMT
Hi Peter I am having the same problem. can you please help. Word version
Office Pro 2003 Sp2. on Win Xp SP2.

> There is a known problem here but only with some versions of Word
>  a. which version of Word? (can you provide the full version number from the
[quoted text clipped - 29 lines]
> >
> > Any Ideas? Please?
Peter Jamieson - 30 Jan 2007 12:52 GMT
If you've already tried using the formatting switches and that hasn't
worked, try working through the suggestions and links in the following
article (and adapt for the UK date sequence):

http://support.microsoft.com/kb/304387/en-us

Peter Jamieson

> Hi Peter I am having the same problem. can you please help. Word version
> Office Pro 2003 Sp2. on Win Xp SP2.
[quoted text clipped - 43 lines]
>> >
>> > Any Ideas? Please?
Doug Robbins - Word MVP - 30 Jan 2007 15:52 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

> Hi Peter I am having the same problem. can you please help. Word version
> Office Pro 2003 Sp2. on Win Xp SP2.
[quoted text clipped - 43 lines]
>> >
>> > Any Ideas? Please?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.