Re: Date format is not uniform

From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 07/24/04 

Date: Sun, 25 Jul 2004 00:36:46 +0100

If you're inserting the date using a MERGEFIELD field, use e.g.

{ MERGEFIELD mydate \@"MM/DD/YY" }

If you're inserting the date in a column in a DATABASE field, you will
probably need to use a function such as format() in the Query SQL to convert
the date to the string value you need. 

-- 
Peter Jamieson
"Dave" <kc8lcw@insight.rr.com> wrote in message
news:352301c471bc$86313a60$a601280a@phx.gbl...
> I am using MS-Word 2002 and importing data into a form
> letter from an MS-Access 2000 database query.  I have the
> date format in the database (table, form, query and
> report) set to "short date".  When the field is merged
> into the form letter, MS-Word converts the short date
> into the "general date" format.  How can I resolve this
> problem?
>
> example:
> database date format = mm/dd/yy
> word displays as: yyyy-mm-dd 00:00:00
>
> Any help would be greatly appreciated.
>
> Dave

Relevant Pages