How do I change the format of the Year

[rahulroy08]

Hi,

In my report I want to display the Month and year for a date entered by the user.

Say if the date entered is [1/1/2007]

My report should display

As of [bold] January 2007 [/bold]

And for that I'm using the following formula

MonthName(Month({?Start_Date})) + " " + totext(tonumber (Year({?Start_Date})))

But it displays as

As of [bold] January 2,007.00 [/bold]

How do I correct this..

Can any one suggest a better formula for this.


Thanks,

Uday.

 

[synapsevampire]

Try:

MonthName(Month({?Start_Date})) + " " + totext(tonumber (Year({?Start_Date}),0,""))

The 0 is the number of decimals, the "" is the thousands seperator.

-k