Reply
 
Thread Tools Display Modes
  #1   Report Post  
Curious of Barnet
 
Posts: n/a
Default Word Mailmerge reading UK dates in Access as US dates

I have an Access Database which contains a date field, formatted as a UK
date, i.e. dd/mm/yy hh:mm. When I use the Word mailmerge facility to pull in
information about an overdue book loan the date is read by word as being in
US format, i.e. mm/dd/yy hh:mm, so that 5th November 2003 is printed in the
mailmerge as 11th May 2003. How do I make Mailmerge read the date correctly?
  #2   Report Post  
Dawn
 
Posts: n/a
Default

When you are in Word, right click on the date filed and select edit field.
Click on Field codes, and where you MERGEFIELD Date(or whatever you named the
field) type
\@ dd/MM/yyyy

You need to use capital "M", this way Word knows you mean months instead of
minutes.

Hope this helps.


"Curious of Barnet" wrote:

I have an Access Database which contains a date field, formatted as a UK
date, i.e. dd/mm/yy hh:mm. When I use the Word mailmerge facility to pull in
information about an overdue book loan the date is read by word as being in
US format, i.e. mm/dd/yy hh:mm, so that 5th November 2003 is printed in the
mailmerge as 11th May 2003. How do I make Mailmerge read the date correctly?

  #3   Report Post  
Curious of Barnet
 
Posts: n/a
Default

Thanks, but ...

Doesn't solve the problem; I was already doing that.

The problem occurs on the network of the school I work in but not at home.
At school it only happens with a date that has the day = 12. If the day
12 in the original Access file, it does not happen.

"Dawn" wrote:

When you are in Word, right click on the date filed and select edit field.
Click on Field codes, and where you MERGEFIELD Date(or whatever you named the
field) type
\@ dd/MM/yyyy

You need to use capital "M", this way Word knows you mean months instead of
minutes.

Hope this helps.


"Curious of Barnet" wrote:

I have an Access Database which contains a date field, formatted as a UK
date, i.e. dd/mm/yy hh:mm. When I use the Word mailmerge facility to pull in
information about an overdue book loan the date is read by word as being in
US format, i.e. mm/dd/yy hh:mm, so that 5th November 2003 is printed in the
mailmerge as 11th May 2003. How do I make Mailmerge read the date correctly?

  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

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/cindy...r/MergFram.htm


--
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
"Curious of Barnet" wrote in
message ...
Thanks, but ...

Doesn't solve the problem; I was already doing that.

The problem occurs on the network of the school I work in but not at home.
At school it only happens with a date that has the day = 12. If the day

12 in the original Access file, it does not happen.

"Dawn" wrote:

When you are in Word, right click on the date filed and select edit
field.
Click on Field codes, and where you MERGEFIELD Date(or whatever you named
the
field) type
\@ dd/MM/yyyy

You need to use capital "M", this way Word knows you mean months instead
of
minutes.

Hope this helps.


"Curious of Barnet" wrote:

I have an Access Database which contains a date field, formatted as a
UK
date, i.e. dd/mm/yy hh:mm. When I use the Word mailmerge facility to
pull in
information about an overdue book loan the date is read by word as
being in
US format, i.e. mm/dd/yy hh:mm, so that 5th November 2003 is printed in
the
mailmerge as 11th May 2003. How do I make Mailmerge read the date
correctly?



  #5   Report Post  
Curious of Barnet
 
Posts: n/a
Default

Thanks, Doug, you are a gentleman and a scholar. I suspected all along that
it was a bug, but could not show my student how to fix it so she used dates
with days greater than 12 and it was OK. Now we can fix it properly. Thanks
heaps.

David

"Doug Robbins" wrote:

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/cindy...r/MergFram.htm


--
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
"Curious of Barnet" wrote in
message ...
Thanks, but ...

Doesn't solve the problem; I was already doing that.

The problem occurs on the network of the school I work in but not at home.
At school it only happens with a date that has the day = 12. If the day

12 in the original Access file, it does not happen.

"Dawn" wrote:

When you are in Word, right click on the date filed and select edit
field.
Click on Field codes, and where you MERGEFIELD Date(or whatever you named
the
field) type
\@ dd/MM/yyyy

You need to use capital "M", this way Word knows you mean months instead
of
minutes.

Hope this helps.


"Curious of Barnet" wrote:

I have an Access Database which contains a date field, formatted as a
UK
date, i.e. dd/mm/yy hh:mm. When I use the Word mailmerge facility to
pull in
information about an overdue book loan the date is read by word as
being in
US format, i.e. mm/dd/yy hh:mm, so that 5th November 2003 is printed in
the
mailmerge as 11th May 2003. How do I make Mailmerge read the date
correctly?




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
How can I divide a page into three sections? Bonnie Microsoft Word Help 3 May 8th 23 02:47 AM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
Macro that will add the file path & date to Word footnotes? Rich P Microsoft Word Help 2 December 15th 04 07:49 PM
saving the workspace Mike Microsoft Word Help 3 December 8th 04 11:32 PM
How do I convert a cd in word perfect to microsoft word greylady Microsoft Word Help 1 November 23rd 04 07:03 PM


All times are GMT +1. The time now is 02:38 AM.

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

About Us

"It's about Microsoft Word"