View Full Version : Mailmerge dataconversion


sven2
11-05-2010, 05:33 AM
Hello,

I have a database sitting in SQL server that i would like to mail merge. I use a combination of an Access front-end with an SQL database that keeps the tables and records.

When I connect the word document to sql server express (test server) everything works fine. When I connect the word document to the operating server everything works except the conversion of the datetime fields.

01/01/1900 16:33 should be converted to 16:33 in the word document.
This doesn't work on the oprating server.

Does anybody have an idea why?

Best regards,
Sven.

SQL_Hell
11-16-2010, 05:28 AM
Please give more information, how does the date time conversion not work? it errors or what?

Are the local settings different?