Hi steve,

I think you need some additional parameters in the ToText function:

ToText(Year({?s_date}),0,"")

HTH,

Walter,


>
>I have a string object on my report at the top as part of the heading of the report. The string object is called @HeadingDate or something like that. I build the @HeadingDate string using the formula @HeadingDate. Inside of @HeadingDate formula I look at the Start Date parameter that the user inputs when the report runs. The Start Date parameter is defined as a Date value.
>
>I grab the Month portion of the Start Date and determine which Quarterly report heading to show on the report. I use the Month(X) function to do that and it works. Then I try to do something similar using the Year(X) function to convert the Year using the same Start Date that I used for Month. After I get the year value from the Start Date string I then convert the numeric value to text and append it to the Quarterly report portion of the heading so that in the end I get a report heading something like 1st Quarter 2001. For unknown reasons, Year(X) function is not returning a whole number. I don't want the 2,001.00.
>
>I know about format field, but I can't use it in this case, I don't think. Any idea what to do from here? Thanks again.