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,

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

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

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

It worked in 7703. But, not when I upgraded to 7704.

This has been finally proven to be a bug by support. Everything works fine on a 7703 server, but not on a 7704 server.