Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] 7.7.04 YYMT Date Function

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] 7.7.04 YYMT Date Function
 Login/Join
 
Jay Potter
Guru
posted
I just upgraded to 7.7.4 and I use the code below to convert a DB2 table - numeric date filed to a IB date field. When I display it in a HTML list it displays it properly like so 2012, Jun. When I run the same table in an Active Chart it displays it like so 19040830. Has anybody else run into this? When I run it using a standard chart it display correctly.

DEFINE FILE HOLDLOGN
NEW_DATE/A8YYMD = EDIT(EDIT(DATE),'$99999999');
MONTH/YYMT=NEW_DATE;
END

This message has been edited. Last edited by: Kerry,


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
jnc
Gold member
posted Hide Post
Hello Jay,

Nothing looks wrong with your code, and the data retrival for AHTML vrs HTML really shouldn't be different. Can you test the below code, and see if that reproduces also? Might help you evaluate if you need to open a case. (this produces 2012, AUG in every instance I can find)
DEFINE FILE CAR
DATE/I9 WITH COUNTRY = IF LAST DATE EQ 0 THEN 20120801 ELSE
 LAST DATE + 1;
NEW_DATE/A8YYMD = EDIT(EDIT(DATE),'$99999999');
MONTH/YYMT=NEW_DATE;
END
TABLE FILE CAR
SUM SALES BY COUNTRY BY MONTH
ON TABLE PCHOLD FORMAT AHTML
END


WebFocus 7x, 8x, Win / Linux, any output format
 
Posts: 70 | Location: reading, pa | Registered: April 07, 2007Report This Post
Jay Potter
Guru
posted Hide Post
I actually have opened a case on it and it happens to support also. The Active Reports are not converting it properly. IB is checking it out


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Tom Flynn
Expert
posted Hide Post
Works on 7.6.11 with a COMPUTE:

  
TABLE FILE CAR
SUM
   DEALER_COST
   RETAIL_COST
     COMPUTE PROFIT/P13.2C   = RETAIL_COST - DEALER_COST;
     COMPUTE NEW_DATE/A8YYMD = '&YYMD.EVAL'; NOPRINT
     COMPUTE CUR_DATE/YYMT   = NEW_DATE;
  BY COUNTRY
 ON TABLE PCHOLD FORMAT AHTML
END
-EXIT


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Jay Potter
Guru
posted Hide Post
It worked in 7703. But, not when I upgraded to 7704.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Jay Potter
Guru
posted Hide Post
This has been finally proven to be a bug by support. Everything works fine on a 7703 server, but not on a 7704 server.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] 7.7.04 YYMT Date Function

Copyright © 1996-2020 Information Builders