Data is in Oracle 10g. In DEFINE, use HDATE to convert date to DMYY, followed by DATETRAN to convert to DD-MMM-YYYY. Nearly all data translates properly, except Year 2000 (even have a few 01/01/1901 dates that converted properly). I verified the source data is correct.

Year 200 dates look like: 15-AUG-00ø0



DEFINE ...
EFFDT_DMYY/DMYY=HDATE(EFFECTIVE_DATE, 'DMYY');
EFFDT/A11 =DATETRAN(EFFDT_DMYY, '(DMYY)', '(-T)', 'EN', 11, 'A11');
END

HDATE is used for translating date-time fields. It that what the original field is or is it just a date field? If it's just a date field, use CHGDAT instead.

The date is an Oracle timestamp.

And if you view the field EFFDT_DMYY, what does it look like?

Here's all three dates:

2006/01/19 00:00:00 19/01/2006 19-JAN-2006
2000/08/15 00:00:00 15/08/2000 15-AUG-00ø0
2000/08/15 00:00:00 15/08/2000 15-AUG-00ø0
2005/05/01 00:00:00 01/05/2005 01-MAY-2005

Looks like you found a bug there. I get the same result. You probably will need to open a case with techsupport on this one.

Darin,
Thanks -- I'll let you know what come of this...

Alan

Just a follow-up: I've submitted this as a case to IBI. So far they've duplicated the problem. I will let you know what happens...