Date to DateTime? CR6 and Oracle 8 1

[ainkca]

Hi all,

I've got an Oracle Database(Oracle 8) with Date fields that show on the oracle side as DateTime. Then in Crystal(Crytal 6) it's just a date and I can't see the time at all. Does anyone know what I can do to get the time as well? Since my report will be a 'turnaround time' report, not having the times available is making the data pretty much useless. What can I do to make Crystal see the field as DateTime, the way it is displayed in the actual table?

Thanks... and sorry, I'm new to Crystal AND Oracle... please forgive me if this is a dumb question, I did try to find an answer using the keyword search and FAQ.

ainkca

 

[dpatrickcollins]

There should be a setting in your options or report options window that says what to do with date/time features. Set it from "date" back to "date/time".

Not familiar with version 6 exactly, but I will assume the setting existed back then as well.

 

[ainkca]

Thank you, I will try that

 

[ainkca]

Thank you very much, that did work, and I'm on track again.