cancel
Showing results for 
Search instead for 
Did you mean: 

Time field invalid data

Former Member
0 Kudos

Post Author: bbazian

CA Forum: General

I have a MySQL database with a date and a time field. The date field reports correctly in CRXI but I am unable to get the time field to work. Is there something I need to know on how to format this? I know the data is correct in the database as HH:MM:SS but CR reports it as 12:00:00 am for all records.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: bbazian

CA Forum: General

I did a work around. Changed the MySQL field to a char field and then parsed it and converted it to a time field in the report.

Thanks

Former Member
0 Kudos

Post Author: Jagan

CA Forum: General

In the field browser, does Crystal report the field as being a Date or a DateTime?

Crystal did this to me once too, and I seem to remember finding a 'Convert datetime to date' box that was ticked somewhere in the Options or Report Options menu item.