CR XI -SP6 problem with datetime at "1900-01-01

[agmand]

Hello:

I am working in an VB6 application with Crystal Report XI R2 - SP6 and SQL Server 2005.

All of the reports print the datetime fields with 1 second of difference when the day is "1900-01-01".

Example:
At database:"1900-01-01 10:00:00" at the report "1900-01-01 09:59:59"

Only happens with some hours in the day (10:00, 15:00, etc) and only happens with the date "1900-01-01".

If I add one year to the datetime field, (1901-01-01) the reports works fine.

If I execute the report in Crystal Report 2008 its works fine as well, but Crystal Report 2008 and VB6 are not fully compatible.

Any clues about that?

Thanks for your help and attention.

Agmand

[jggtz]

Maybe the problem is in the driver you are using in Crystal Reports to access the sql data

JG

[agmand]

Thanks for your response.

Mdac 2.8 Sp1 is installed in the machine. (Windows XP Sp3)

It looks like Crystal Report doesnt like the minimun date at Sql Server.

Agmand