Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Merge Fields in Header and Footer | Microsoft Word Help | |||
Merge field to add tomorrow's (or other future) date | New Users | |||
How do I omit an empty date merge field? | Microsoft Word Help | |||
Date mail merge field shows as serial | Mailmerge | |||
using date field in merge | Mailmerge |