Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Frank Santoro
 
Posts: n/a
Default Merge Date Error with change in calendar year

I have a word 2003 merge document that pulls data from an excel 2003
sheet. The specific field I am pulling from (AFRMonth) has the date
12/01/2005. In word, I have the field formatted as follows:

{MERGEFIELD "AFRMonth" \@ "MMMM yyyy"}

so that it should show as "December 2005" in the document. However,
the formatted field is showing as "December 2006" instead. If I change
the system date to 2005, the field shows properly as "December 2005".
If I remove the formatting switches, the field shows "Dec-05"
regardless of the system date.

Any suggestions?

 
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 do i set a reacuring date on a document? welker_daniel New Users 4 October 29th 05 08:38 AM
how do change the american date to the european date? merging from excel to word Mailmerge 1 August 27th 05 06:35 PM
Mail Merge Using Date Filters With SQL Data Source Jonathan Wareham Mailmerge 2 April 25th 05 10:08 AM
How do I control date formatting in a Word Mail Merge? Ric McWaters Mailmerge 1 April 21st 05 04:23 PM
Why does the original date change upon opening a document? K.Local773 Microsoft Word Help 7 December 16th 04 04:15 PM


All times are GMT +1. The time now is 01:05 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"