TO_DATE(DATE, 'DD-MON-RR') error 1

[cocopud]

I am using CR11 and my dates are coming out wrong. 1987 displays as 2087. After some research, I tried to use the TO_DATE(DATE, 'DD-MON-RR') format, but I then get the error: 'ORA-01861: literal does not match format string'

In the Oracle database the dates are shown as DD-MON-YY (Ex: 01-JAN-96). My goal is to have them display in the crystal report as MM/YY (01/96).

What is the best way to do this? I have tried formulas in crystal and end up with 00/00 even when there is a date in the database or errors.

 

[cocopud]

OK I had TO_DATE Instead of TO_CHAR, and I used the format of 'MM/RR')
TO_CHAR(DATE, 'MM/RR')