Hi!
Yes, I just drag the field in crystal right onto the report and it shows the date just fine as a datetime. Then you can rigth click the field and go into "format field"..There you can choose the date format you want to see...

If you need it to be character for some reason other than date formating..
You could use the Oracle TO_CHAR function..
You could for example change your view to something like..
select TO_CHAR(date_field,'YYYY-MON-DD') "DATE" from your_table;

It is just like a focpro DateTime field.. So if you are using foxpro any date time functions work..In crystal the same applies..