Has anyone had this problem before, I have dates in my SQL database that read 2004/09/09 but they show up in Crystal as 2104/09/09. If I try the same report on a different computer I'm getting the correct date. I have checked my regional settings on my computer and they look fine. Is crystal doing any conversion from the database? If so how do I stop it? I'm running CR10.
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
date went screwy 2104 ??
- Thread starter jcoleman
- Start date
synapsevampire
Programmer
What connectivity are you using to SQL Server?
Perhaps you have different ODBC connections or some such?
-k
Perhaps you have different ODBC connections or some such?
-k
- Thread starter
- #3
Same ODBC connections. This actually just started yesterday afternoon. But since yesterday's report didnot show a date I didn't think anything of it. I really don't know what I have changed. And if I did change anything by accident I sure can't find it now.
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question