Business Objects Charts remove decimal and zeros

[BOnovist]

I am using the following :
"Q" & TOTEXT(DatePart("Q",{Registration_List.DateOfClass})) & "-" & TOTEXT({@Date - YY as #})
I am trying to return in my chart "Q1-2008" but I get "Q1.00-2008.00" how do I remove the decimals and following zeros

 

[pavandyke]

I believe you can specify the number of decimal places you want to use in a numbeer field. So your code should say
"Q" & TOTEXT(DatePart("Q",{Registration_List.DateOfClass}), 0) & "-" & TOTEXT({@Date - YY as #}, 0)

 

[BOnovist]

Thank you pavandyke. That worked! Now I am trying to remove the thousand seperator in the year output. I now have:
"Q" & TOTEXT(DatePart("Q",{Registration_List.DateOfClass}), 0) & "-" & TOTEXT(DatePart ("YYYY",{Registration_List.DateOfClass} ),0)

but the output is : "Q1-2,008" and want "Q1-2008" better yet "Q1-08" any help would be great.

 

[BOnovist]

Pavandyke - I figured it out the thousand seperator. I just have not figured out how to make the year = "YY" vs. "YYYY" as the datepart command does not allow "YY".

 

[lbass]

Q" & TOTEXT(DatePart("Q",{Registration_List.DateOfClass}), 0) & "-" & right(TOTEXT(DatePart ("YYYY",{Registration_List.DateOfClass}),0,""),2)

-LB

 

[BOnovist]

Thank you lbass, that did the trick.