Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] MDYY
 Login/Join
 
Member
posted
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>,


WebFOCUS 7.6.5, Windows, Excel
 
Posts: 11 | Registered: August 02, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
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....


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
 
Posts: 252 | Location: USA | Registered: April 15, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
If it has a 2 digit year, then check out DEFCENT and YRTHRESH


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6324 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.