Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
George Mathew
 
Posts: n/a
Default Date Field Merge

I am using MS Word 2002 and MS Excel 2002. My control panel Regional
& Language settings has the date format set d MMM yy. I am having
trouble merging date fields from the worksheet into a Word Document.
Other threads on a similar subject relate to formatting of the output.
My problem is that in some instances the data coming across from the
worksheet is being currupted, by being read as American format and
displaying as the wrong date. The date 11 01 2005 in the worksheet
comes across to the Word document as 1 November 2005 (it should be 11
January 2005) and I can display that November date in any one of
several formats using different date pictures but it will not display
as a January date. Interestingly, the date 17 01 2005 displays in
Word as a 17 January 2005 (correctly) because, it seems, it knows
there are only 12 months in a year so the 17 must be the day and the
other numer the month, I can actually solve the problem by changing
my regional date setting to MMM dd yyyy but then my whole computer is
set up using a format that is quite alien to me. Can anyone help me
to force the data to be read correctly.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default Date Field Merge

Three possibilities:

1. See if the addition of a date switch will fix it eg {Mergefield
datefieldname \@ "d MMM yyyy"} (for more on switches - see
http://www.gmayor.com/formatting_word_fields.htm )
2. Connect to the Excel file using the DDE connection method - see the Excel
data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
3. There's some information about misread dates on Cindy's web site at
http://homepage.swissonline.ch/cindymeister

--

Graham Mayor - Word MVP

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


George Mathew wrote:
I am using MS Word 2002 and MS Excel 2002. My control panel Regional
& Language settings has the date format set d MMM yy. I am having
trouble merging date fields from the worksheet into a Word Document.
Other threads on a similar subject relate to formatting of the output.
My problem is that in some instances the data coming across from the
worksheet is being currupted, by being read as American format and
displaying as the wrong date. The date 11 01 2005 in the worksheet
comes across to the Word document as 1 November 2005 (it should be 11
January 2005) and I can display that November date in any one of
several formats using different date pictures but it will not display
as a January date. Interestingly, the date 17 01 2005 displays in
Word as a 17 January 2005 (correctly) because, it seems, it knows
there are only 12 months in a year so the 17 must be the day and the
other numer the month, I can actually solve the problem by changing
my regional date setting to MMM dd yyyy but then my whole computer is
set up using a format that is quite alien to me. Can anyone help me
to force the data to be read correctly.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Date Field Merge

See the following Knowledgebase article:

"Month and day are not displayed in the order that you expect in a mail
merge document linked to an external data source in Word 2002"

at

http://support.microsoft.com/kb/327579/

Peter Jamieson

"George Mathew" wrote in message
...
I am using MS Word 2002 and MS Excel 2002. My control panel Regional
& Language settings has the date format set d MMM yy. I am having
trouble merging date fields from the worksheet into a Word Document.
Other threads on a similar subject relate to formatting of the output.
My problem is that in some instances the data coming across from the
worksheet is being currupted, by being read as American format and
displaying as the wrong date. The date 11 01 2005 in the worksheet
comes across to the Word document as 1 November 2005 (it should be 11
January 2005) and I can display that November date in any one of
several formats using different date pictures but it will not display
as a January date. Interestingly, the date 17 01 2005 displays in
Word as a 17 January 2005 (correctly) because, it seems, it knows
there are only 12 months in a year so the 17 must be the day and the
other numer the month, I can actually solve the problem by changing
my regional date setting to MMM dd yyyy but then my whole computer is
set up using a format that is quite alien to me. Can anyone help me
to force the data to be read correctly.



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
George Mathew
 
Posts: n/a
Default Date Field Merge

Graham

I struggled with this problam until well after midnight this morning -
then posted to this NG and went to bed. Got up this morning to find
that two kind people, I assume in a quite different time zones, have
responded. Thanks to you and Peter Jamieson. You pointed me to a
number of URLs and I have now solved the problem. I have installed
Office XP SP3 and it now works well. That is a fix I needed.

On Tue, 24 Jan 2006 16:39:30 +0200, "Graham Mayor"
wrote:

Three possibilities:

1. See if the addition of a date switch will fix it eg {Mergefield
datefieldname \@ "d MMM yyyy"} (for more on switches - see
http://www.gmayor.com/formatting_word_fields.htm )
2. Connect to the Excel file using the DDE connection method - see the Excel
data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
3. There's some information about misread dates on Cindy's web site at
http://homepage.swissonline.ch/cindymeister

--

Graham Mayor - Word MVP

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


George Mathew wrote:
I am using MS Word 2002 and MS Excel 2002. My control panel Regional
& Language settings has the date format set d MMM yy. I am having
trouble merging date fields from the worksheet into a Word Document.
Other threads on a similar subject relate to formatting of the output.
My problem is that in some instances the data coming across from the
worksheet is being currupted, by being read as American format and
displaying as the wrong date. The date 11 01 2005 in the worksheet
comes across to the Word document as 1 November 2005 (it should be 11
January 2005) and I can display that November date in any one of
several formats using different date pictures but it will not display
as a January date. Interestingly, the date 17 01 2005 displays in
Word as a 17 January 2005 (correctly) because, it seems, it knows
there are only 12 months in a year so the 17 must be the day and the
other numer the month, I can actually solve the problem by changing
my regional date setting to MMM dd yyyy but then my whole computer is
set up using a format that is quite alien to me. Can anyone help me
to force the data to be read 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
Link Merge Fields in Header and Footer jeanmac Microsoft Word Help 9 September 12th 05 10:50 PM
Merge field to add tomorrow's (or other future) date Gill W New Users 0 July 26th 05 09:37 PM
How do I omit an empty date merge field? Phildeman Microsoft Word Help 5 June 13th 05 03:29 PM
Date mail merge field shows as serial Hiking Mailmerge 5 March 18th 05 11:25 AM
using date field in merge Henri Vrancken Mailmerge 3 March 5th 05 02:52 PM


All times are GMT +1. The time now is 03:22 PM.

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"