Year Displays with a comma 1

[nb4884]

Hi All,

I have a formula to display current Year in Header.

@Year = (year(currentdate))

but this displays as 2,011.00

How do I display it as 2011

Thanks

 

[MCuthill]

nb4884,

You can simply right-click and format the formula field. If it is then imbedded in another Text Field, or used in another manner where this is not an option, change your formula to the following:

{@Year}

ToText(Year(CurrentDate),0,"")

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[nb4884]

Thanks Mike, the field was not right click-able but the formula worked very well.