Strange issue with dates...

[bessebo]

We have Crystal Enterprise 9 installed in our Test Room as well as in production. For some reason, out of the blue, when we create a report in our test environment and run it the dates show up as 100 years plus 1 day greater than the actual date in the database. I think this started happening after we retored from our production database the last time but I'm not sure of it. All I know is that our dates are for some reason inexplicably inflated. Would anyone out there know what could be causing this?

Thanks,
Bessebo

 

[synapsevampire]

Try posting technical information:

"when we create a report in our test environment and run it the dates show up as 100 years plus 1 day greater than the actual date in the database."

What database? Do youmean the CE database is now incorrect, or the dates in the database that the report is hitting?

What connectivity are you using?

I suggest placing CR on the CE server for this sort of testing.

Anyway, Crystal isn't going to add a year unless something changed, such as the connectivity to the database, or the database does have a different date now.

-k

 

[bessebo]

CR is already on the CE server in our test environment. Our ERP database dates are showing 100 years + 1day and the dates in the database are fine (as seen using Query Analyzer). ODBC(RDO) is used for database connectivity.