[Twb]

I have a database that has several felds within it with the Date/Time Format.
the format in the database for all these fields are set to Short date. In
the table the data is shown as 13/08/2009

I've created a letter in word and is using the database as the datasource.

When I merge the document with my data from the database all the Date/Time
fields in the letter show the date as 13/08/09 00:00:00.

Please help as I've tried everything to get it to show correctly.

[Twb]

"Twb" wrote:

I have a database that has several felds within it with the Date/Time Format.
the format in the database for all these fields are set to Short date. In
the table the data is shown as 13/08/2009

I've created a letter in word and is using the database as the datasource.

When I merge the document with my data from the database all the Date/Time
fields in the letter show the date as 13/08/09 00:00:00.

Please help as I've tried everything to get it to show correctly.

i'm using office 2003 sorry forgot to say.

[Doug Robbins - Word MVP]

See the "Date-Time Picture (\@) field switch" section of the "Formatting
Word fields with switches" article on fellow MVP Graham Mayor's website at :

http://www.gmayor.com/formatting_word_fields.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, originally posted via msnews.microsoft.com
"Twb" wrote in message
...
I have a database that has several felds within it with the Date/Time
Format.
the format in the database for all these fields are set to Short date. In
the table the data is shown as 13/08/2009

I've created a letter in word and is using the database as the datasource.

When I merge the document with my data from the database all the Date/Time
fields in the letter show the date as 13/08/09 00:00:00.

Please help as I've tried everything to get it to show correctly.

[Twb]

Hi Dough,
i tried this but no joy.....on further investgation i've viewed the Mail
merge Recipients window in word and it shows all the Date fields entry as
19/07/1965 00:00:00. however in access where the data comes from it is
formated as a date field and the only entry in the field is 19/07/1965.

"Doug Robbins - Word MVP" wrote:

See the "Date-Time Picture (\@) field switch" section of the "Formatting
Word fields with switches" article on fellow MVP Graham Mayor's website at :

http://www.gmayor.com/formatting_word_fields.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, originally posted via msnews.microsoft.com
"Twb" wrote in message
...
I have a database that has several felds within it with the Date/Time
Format.
the format in the database for all these fields are set to Short date. In
the table the data is shown as 13/08/2009

I've created a letter in word and is using the database as the datasource.

When I merge the document with my data from the database all the Date/Time
fields in the letter show the date as 13/08/09 00:00:00.

Please help as I've tried everything to get it to show correctly.

[Doug Robbins - Word MVP]

You could use the Format() function in a Query in Access to convert the date
to text, or set the option to Confirm file conversion at open (via
ToolsOptions in versions before 2007 or via the Office ButtonWord
OptionsAdvanced in 2007) and then when you connect the data source to the
mail merge main document, select the DDE option.

--
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, originally posted via msnews.microsoft.com
"Twb" wrote in message
...
Hi Dough,
i tried this but no joy.....on further investgation i've viewed the Mail
merge Recipients window in word and it shows all the Date fields entry as
19/07/1965 00:00:00. however in access where the data comes from it is
formated as a date field and the only entry in the field is 19/07/1965.

"Doug Robbins - Word MVP" wrote:

See the "Date-Time Picture (\@) field switch" section of the "Formatting
Word fields with switches" article on fellow MVP Graham Mayor's website
at :

http://www.gmayor.com/formatting_word_fields.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, originally posted via msnews.microsoft.com
"Twb" wrote in message
...
I have a database that has several felds within it with the Date/Time
Format.
the format in the database for all these fields are set to Short date.
In
the table the data is shown as 13/08/2009

I've created a letter in word and is using the database as the
datasource.

When I merge the document with my data from the database all the
Date/Time
fields in the letter show the date as 13/08/09 00:00:00.

Please help as I've tried everything to get it to show correctly.