Date format when retrieving from the database is wrong

[Naiyanad Ohpanayikool <naiyanad.ohpanayikool@ACCENTURE.COM>]

The date format which is kept in the database is YYYY i.e. 1977.

But when I code SQR to retrieve the date field, and print out on the
report, using

print $date () Edit 'DD/MM/YYYY'

The result come out on the report is 2077, not 1977. How can I set SQR to
know that the date is in year 19xx not 20xx?

BRIO Report Builder 6.1.3
SQR 6.0
ORACLE 8i
Windows NT 4.0

Best regards,
Nai
______________________________
Naiyanad Ohpanayikool
Microsoft Solution Organisation, Accenture Bangkok
Tel: +662 636-1616


This message is for the designated recipient only and may contain
privileged or confidential information.  If you have received it in error,
please notify the sender immediately and delete the original.  Any other
use of the email by you is prohibited.