Date format Database to Word changes

>I created at a Word filke containing field and the data is from my
>database (via ODBC).
>
>One of the fields is Date. The format in the database is dd-mm-yyyy (I
>checked it in VB code), but in the Word file it is yyyy-mm-dd.
>The Regional Settings from Windows is set to dd-mm-yyyy.
>
>How to have the fields in Word listed to this format as well? The same
>field also add time as 00:00:00 while there is no Time issue at all.
>
>So:
>
>MDB file
>15-10-2006
>
>Word file
>2006-10-15
>00:00:00
>
>
>Bart

On 17 Oct 2006 05:41:23 -0700, "AA Arens" <bartvandon...@gmail.com>
wrote:
>
Rather than merging against the table, you can merge against a query
that formats the data the way you want.
Date is a reserved word. I wouldn't use it for a field name.
>
-Tom.
>>>>>>>

>Consider a connection table - Word, how to have the date format solved?
>This should be not a headache issue. Thank you.
>(BTW, the fieldname and column are called ModDate.)
>
>On Oct 17, 8:55 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote: