Date/Time format problem merging EXCEL or Access info

[Dan]

Word 2002, EXCEL 2002 and Access 2002 problem: When I
merge an EXCEL table or an Access table to a Word
document, the date and time formats on the source date are
not carried into the merged Word document. I need to have
July 30, 2003 (in either table) repeated in my doc, not
7/30/2003.
Any suggestions? Thanks...

 

[Peter Jamieson]

Use date format switches within the Word fields, e.g. instead of

{ MERGEFIELD mydate }

use

{ MERGEFIELD mydate \@"MMMM D, YYYY" }

The switches are documented in Word Help.