dynamically display cal years into CY with YY

building reports webintelligence
1

Hi guys,
how can i display years in crosstab 2001 as CY01, 2002 as CY02, 2002 as CY03 etc.

having problem converting datetype to char where i need to do concatenate with CY. tried two ways.
1.example for calyr=2009 when i do year(currentdate())-1 shows 09 then i cannot cnocatenate this with CY text. need to convert this datetype to string.

2.i tried formateDate function whr it gives results into string but in results it shows small square box when i concatenate with CY.

suggestions are greatly appreciated.

Thanks
PV

sownu (BOB member since 2009-08-27)

2

use this function;

=Replace([Year_Object];“20”;“CY”)

This will work.

vangaras (BOB member since 2005-03-14)