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
COMPUTE DATE/I8YYMD = TRADOD; AS 'DATE YYMD'
J1BFANAM AS 'Supervisor Name'
BY TREMPN NOPRINTThis message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 7.6.5, Windows, Excel
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
DevStu WF 7.6.11
HTML, PDF, EXL2K
If it has a 2 digit year, then check out DEFCENT and YRTHRESH
|Powered by Social Strata|