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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [RESOLVED] More fun with Dates
Go
New
Search
Notify
Tools
Reply
  
[RESOLVED] More fun with Dates
 Login/Join
 
Platinum Member
posted
I can get the date format Oct-2010 if I use the following code:

COMPUTE DT1/DMY = HDATE(DB_DATE_FIELD, 'DMYY');
COMPUTE DT2/MYY = DT1 ;
COMPUTE DT3/A10 = DATETRAN(DT2,'(MYY)','(-dt)','EN',10,'A10');

But I need October-2010.

If I change the code to

COMPUTE DT3/A13 = DATETRAN(DT2,'(MTrYY)','(-dt)','EN',13,'A13');

I get blanks for DT3. Any ideas why?

This message has been edited. Last edited by: Ted Michalski,


7.7.02
Windows
EXCEL, PDF, CSV, TEXT
 
Posts: 106 | Registered: June 25, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try this instead. Output formatting is being done by the third parameter, not the second.

COMPUTE DT3/A10 = DATETRAN(DT2,'(MYY)','(-dtr)','EN',15,'A15');


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
THANKS! That works.


7.7.02
Windows
EXCEL, PDF, CSV, TEXT
 
Posts: 106 | Registered: June 25, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [RESOLVED] More fun with Dates

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