We are converting from 524 TO 766, and I can't seem to get a date to appear correctly. Below I've included the master file definition, the applicable portion of the program, and output from before/after. Can anyone remember running into this while updating to 766?

SUFFIX=SQLMSS ,$
...
FIELD=DATE ,Date,
ACTUAL=YYMD ,USAGE=MDYY ,MISSING=OFF,$
...
DEFINE FILE CDSCOMPOSITESBYCONVENTION
CURR_CDS_DT2/MDYY = DATE;
...
DEBTCLASS /A3 = 'SEN';
OUT_DAT /A8YYMD = CURR_CDS_DT2;
REFTCKR /A25 = CUR||P2||REF||'.U'||P2||DEBTCLASS||P;
SPRDREC /A73 = P||1Yt||P||2Yt||P||3Yt||P||4Y||P||5Yt||P||7Yt||P||10Yt||P||12Y||P||15Yt||P||20Yt||P||30Yt||P;
CDS_SPREADS /A110 = REFTCKR||OUT_DAT||SPRDREC;
END

TABLE FILE HOLD_CDS
PRINT
CDS_SPREADS
ON TABLE SAVE AS SAVEIT
END
-RUN
-QUIT


OUTPUT PRIOR TO CONVERSION TO 766 (NOTE DATE FORMAT)

USD/ABK.U/SEN|20090210|2660|1990|1751|0|1496|1295|1134|0|1061|1006|988|
USD/AIG.U/SEN|20090210|592|556|537|0|494|449|403|0|412|428|425|

NOW LOOKS LIKE THIS:

USD/ABK.U/SEN|19010912|18|27|34|0|49|59|70|0|72|79|66|
USD/ABK.U/SEN|19010912|7|10|14|0|21|28|36|0|40|39|40|

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

This may be related to Y2K issues. Perhaps your DATE field does not contain the century. Perhaps you had SET DEFCENT = 20 in edasprof.prf or site.wfs or some other profile in the 5.2.4 version and do not have it in the 7.6.6 version.

Also, did you regenerate the metadata (acx and mas) or just copy it?

Thanks Francis! I'll look at those.

Chris, this

FIELD=DATE ,Date,
ACTUAL=YYMD ,USAGE=MDYY ,MISSING=OFF,$

should be

FIELD=DATE ,Date,
ACTUAL=DATE ,USAGE=MDYY ,MISSING=OFF,$

Also, I would definitely name the field to be something more meaningful then generic, like TRADE_DATE or something like that.

Rick

THANK YOU!!!