Mailmerge dataconversion

[sven2]

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]

Please give more information, how does the date time conversion not work? it errors or what?

Are the local settings different?