Access to Word - Date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Ezekiel - 04 Feb 2004 22:38 GMT

I have data on an Access database. One of the fields is a
date and is entered on the database in dd/mm/yyyy format.
When merged into a Word document it is re-formatted into
mm/dd/yyyy format (i.e. from International to US format).
As far as I can figure, everything is set to English (UK)
so what am I doing wrong?

Reply to this Message

Graham Mayor - 05 Feb 2004 06:43 GMT

Word 2002/3?

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm (the issue is the
same with Excel).

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have data on an Access database. One of the fields is a
> date and is entered on the database in dd/mm/yyyy format.
> When merged into a Word document it is re-formatted into
> mm/dd/yyyy format (i.e. from International to US format).
> As far as I can figure, everything is set to English (UK)
> so what am I doing wrong?

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 05 Feb 2004 06:44 GMT

Hi Bill,

The surest way to overcome this problem is to use an Access Query as the
datasource and in that Query, use the Format([Datefield], "dd/mm/yyyy")
function to force the date into that format.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

>I have data on an Access database. One of the fields is a
> date and is entered on the database in dd/mm/yyyy format.
> When merged into a Word document it is re-formatted into
> mm/dd/yyyy format (i.e. from International to US format).
> As far as I can figure, everything is set to English (UK)
> so what am I doing wrong?

Reply to this Message