DATETRAN to convert to DD-MMM-YYYY. Nearly all data translates properly, except Year 2000

Year 200 dates look like: 15-AUG-00ø0
Please give some solutions for the above requirement

Hi Shakila,
I have also encountered the same problem. Please see my post Y2K problem for more details.

It looks like it is a known problem . You may need to find a turnaround solution for it as an interim solution.

Try using CHGDAT to convert your date to DD MMM YYYY format (DMTYY) and then use EDIT to insert the dashes. Be aware that CHGDAT will convert the format to an A17.

Hi all,

FYI, this is a known problem and already submitted to programming to fix it.

Hope this helps.

Cheers,

Kerry