I have create a word document using an Excel worksheet as my database. The
date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy using
the sql query function or yyyy/mm/dd if the data source is ODBC. How do I get
the format I require with out making the 'date field' in the worksheet a text
field??

Try this, Colin:
http://www.officearticles.com/word/m...osoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Colin in RSA" wrote in message
...
I have create a word document using an Excel worksheet as my database. The
date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy
using
the sql query function or yyyy/mm/dd if the data source is ODBC. How do I
get
the format I require with out making the 'date field' in the worksheet a
text
field??

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/cindy...r/MergFram.htm

--
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

"Colin in RSA" wrote in message
...
I have create a word document using an Excel worksheet as my database. The
date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy
using
the sql query function or yyyy/mm/dd if the data source is ODBC. How do I
get
the format I require with out making the 'date field' in the worksheet a
text
field??

Thanks 1,000,000 Anne & Doug for the assistance - you saved me from going bald.

"Anne Troy" wrote:

Try this, Colin:
http://www.officearticles.com/word/m...osoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Colin in RSA" wrote in message
...
I have create a word document using an Excel worksheet as my database. The
date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy
using
the sql query function or yyyy/mm/dd if the data source is ODBC. How do I
get
the format I require with out making the 'date field' in the worksheet a
text
field??

You're welcome, Colin!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Colin in RSA" wrote in message
...
Thanks 1,000,000 Anne & Doug for the assistance - you saved me from going
bald.

"Anne Troy" wrote:

Try this, Colin:
http://www.officearticles.com/word/m...osoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Colin in RSA" wrote in message
...
I have create a word document using an Excel worksheet as my database.
The
date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy
using
the sql query function or yyyy/mm/dd if the data source is ODBC. How do
I
get
the format I require with out making the 'date field' in the worksheet
a
text
field??