date error

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

i'm using office 2003.

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.

Please help as I've tried everything even \@ and that did not work in in the
merge code to get it to show correctly.

 

[Piet Linden]

I have a database that has several felds within it with the Date/Time Format.





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.

Please help as I've tried everything even \@ and that did not work in in the
merge code to get it to show correctly.

You could try basing your merge on a query and using the Format$
function to convert the date field to a text field.