Hi,

I have capacity_year which is I11 datatype and capacity_month which is I11 datatype. I want to display CYEAR_CMONTH in my report ...

Is there a way to do this?

Please suggest.

Thank you,
priya

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

Have you thought about using a DEFINE or COMPUTE to create the Yesr Month Field ?

This is very simple stuff.

TABLE FILE CAR
PRINT 
COMPUTE YEAR/I11 = 2012 ;
COMPUTE MONTH/I11 = SEATS ;
COMPUTE IYEAR_MONTH/I6YYM = (YEAR * 100) + MONTH;
COMPUTE CYEAR_MONTH/YYM = IYEAR_MONTH ;

WHERE RECORDLIMIT EQ 1
END

Hi Waz thank you I will try this and see.

SOLVED