I'm retriving data from a "MySQL" database into CR10. The data field contains an entered time (ex. 3:45pm). When I view the CR data the time appears as (ex. 12:00am). The data is being entered via a web site and I suspect that the program is at fault. Is there anything outside the norm that I may have missed in CR. The "time format" in "options" is set properly.
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Time problem
- Thread starter brianjay
- Start date
akabatman2
Programmer
A couple things to try is to do a "verify database" and then browse the time field in crystal to make sure you are seeing the correct time. If the time from the database matches the time in the crystal data browser then right click on the time field and choose a time display format or create a custom format.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question