date error

  • Thread starter Thread starter Twb
  • Start date Start date
T

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.
Click to expand...

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.
 
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.
Click to expand...

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