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
  
Unusual date format
 Login/Join
 
Guru
posted
We have a 9 character claim number wherein the first character points to the last digit of the year (0 = 2000, 1 = 2001, etc.) and the next three characters indicates the day of the year (either 090 or 091 is for April Fools' Day, depending on whether it's a leap year or not.) How can we convert these characters to either a YYMD or YYJUL format?

Thanks in advance,
Sandy Confused
 
Posts: 239 | Location: Orlando, FL / Baltimore, MD | Registered: May 06, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Try this example:
TABLE FILE CAR<br />  PRINT <br />    COMPUTE CLAIM/A9     = '411300000' ;<br />    COMPUTE JULDATEA/A7  = '200' | EDIT(CLAIM, '9999') ; <br />    COMPUTE JULDATEI/I7L = EDIT(JULDATEA) ;<br />    COMPUTE DATEI/I8YYMD = GREGDT(JULDATEI, 'I8YYMD') ;<br />  BY COUNTRY<br />END
Regards,
Mikel
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 


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