Formatting year

[mart10]

I am using CR XI

I need to format the following :

If (Month ({FXRATES.rate_dt}))= 1 then Year ({FXRATES.rate_dt}) else
If (Month ({FXRATES.rate_dt}))= 2 then Year ({FXRATES.rate_dt}) else
If (Month ({FXRATES.rate_dt}))= 3 then Year ({FXRATES.rate_dt}) else
(Year ({FXRATES.rate_dt})+1)

AS 2009 or say 2010 (depending upon the month) I am including this formula into a text box and it comes out with
2,009.00 or 2,010.00 - I need to drop the comma and the decimals

For the second part of my question its the same as above except need to show abreviated year

That is output of 09 and 10

 

[IanWaterman]

Just highlight formula in text box right click select format normal number format dialog box should open.

Create new formula
@yearYY

right(totext({yourformula),0,""),2)

Ian