I have a numeric string on field TRADOD. I added a compute to convert into a date, but if I update the compute to I8MDYY, the output shows year 1900. What can I add to the file to make it show in MDYY format with the correct year output?

TABLE FILE TR01
PRINT
TREMPN
J1BFLNAM
J1BFFNAM
J1BFANAM
TRADOD
COMPUTE DATE/I8YYMD = TRADOD; AS 'DATE YYMD'
TRHRWK
TRCDLN
TRDESC
J1BFBADG
J1BFSHFT_CODE
J1BFHDPL
J1BFHDPP
J1BFSPVR
J1BFANAM AS 'Supervisor Name'
BY TREMPN NOPRINT

This message has been edited. Last edited by: <Kathryn Henning>,

First, what does the numeric string look like? Is it eight digits which look like a date? What you are doing is a simple assignment and the input format may require something more elaborate.

Second, the label DATE might be a reserved word in WebFOCUS so use a different label such as
COMPUTE DODDATE/I8YYMD....

If it has a 2 digit year, then check out DEFCENT and YRTHRESH