huskerfan1
IS-IT--Management
I have a date field in my database that is default 01/01/0001. When Crystal reads that field it is returning 1/1/2001. Any ideas on how to correct that?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using ODBC Connection - Date Problem
- Thread starter huskerfan1
- Start date
- Status
synapsevampire
Programmer
Consider sharing the type of database, ODBC connection used, and how you've verified what's stored in the database and in CR.
It may be that the database is NOT storing it that way, SmallDateTime cannot go back that far...a DateTime can.
-k kai@informeddatadecisions.com
It may be that the database is NOT storing it that way, SmallDateTime cannot go back that far...a DateTime can.
-k kai@informeddatadecisions.com
- Thread starter
- #3
huskerfan1
IS-IT--Management
I am using Crystal Reports 9.0 and a Client Access ODBC Driver Version 4, release 4 for a DB2 envornoment.
The date came across fine in CR 8.5 - now that I upgraded to 9 it is a problem. I assume it is something in the default settings on 9.0,
The date came across fine in CR 8.5 - now that I upgraded to 9 it is a problem. I assume it is something in the default settings on 9.0,
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question