Return Year as Date not whole number 2

[epoh]

How can I return the date in the report paramater as "2006" instead of "2,006.00"

I am using this code to return the date:

[COLOR=blue]
Year({?@Beginning_Date}) [/color]

I have tried Cstr, ToText, ToNumber with no success.

 

[Kendel]

Will thsi work?

ToText(Year({?@Beginning_Date}),"0000")

 

[BobSuruncle]

Year() returns the numeric value of the year from a valid Date or DateTime field.

Crystal's default formatting for numbers includes 2 decimal places and a thousands separator.

If you're simply placing the formula field on the report canvas, you could just format the field using the Format Editor (right-click the field and choose Format from the shortcut menu)


Bob Suruncle

 

[mocgp]

FYI - If using this in a formula, the syntax is

CStr(Year({DateField}),0,"")

CStr and ToText are interchangeable.

 

[epoh]

Thanks Bob!