By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,360 Members | 3,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,360 IT Pros & Developers. It's quick & easy.

Date format Database to Word changes

P: n/a
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

Oct 17 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 17 Oct 2006 05:41:23 -0700, "AA Arens" <ba***********@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.

>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
Oct 17 '06 #2

P: n/a
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:
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.
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
Oct 18 '06 #3

P: n/a
On 18 Oct 2006 06:32:49 -0700, "AA Arens" <ba***********@gmail.com>
wrote:

I'm not sure what you mean by a "connection table", but I would create
a query along these lines:
select FirstName, LastName, Format(ModDate,"dd-mm-yy") as FModDate
from SomeTable

-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:
>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.
>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
Oct 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.