Insert Field - Database - Wrong Date Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dns2005 - 22 Feb 2006 15:31 GMT

Please help!!

I've had an ongoing problem with inserting a database query into a word
document via the Insert Field option, in that the date format changes from UK
to US during the transfer from MS Access to Word. I'm using Office 2003 and
all SPs are up to date. I've checked the language settings and this is set to
UK default (both within Control Panel and also MS Office Language settings.
I had this problem previously when using Office XP and had hoped that
upgrading would resolve it, unfortunately this was not the case. The steps I
follow are:

Within MS Word - Insert Menu, Field, Database, Insert Database, Get Data,
Select the relevant MS Access DB and then the Query, Insert All and check the
Insert Data as Field option, however, still I end up with a US date format.

Within the database itself the date shows as UK and the original table entry
is set to Date/Time, Short Date.

Any advice you could offer would be greatly appreciated.

Thanks again.

Reply to this Message

Doug Robbins - Word MVP - 22 Feb 2006 18:40 GMT

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Please help!!
>
[quoted text clipped - 25 lines]
>
> Thanks again.

Reply to this Message

dns2005 - 23 Feb 2006 14:22 GMT

Hi Doug

Thanks for your advice, I've tried changing the connection methods and still
encounter the same error. I daresay I'll have to live with formatting the
field as Text within the database.

Thanks again though, much appreciated.

Donna

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 31 lines]
> >
> > Thanks again.

Reply to this Message

Cindy M -WordMVP- - 23 Feb 2006 16:04 GMT

Hi =?Utf-8?B?ZG5zMjAwNQ==?=,

> Thanks for your advice, I've tried changing the connection methods and still
> encounter the same error. I daresay I'll have to live with formatting the
> field as Text within the database.

Set up a query (rather than using a table). In the query, instead of using the
data field directly, create an expression:

xDate: Format({datefield}, "m/d/yy")

this will pass the information as literal text and Word won't try to "fiddle"
how it displays. "xDate" can be anything you like, it's what will appear as the
field name in the resultant dynaset. Put the field name in the braces.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message