Year with commas

[Dukester0122]

My formula shows the month and year of the columns but the year is showing with commas, can somebody tell me what I need to add to this formula:

totext(Month({?ReportDate}),0) + "/" + totext(Year({?ReportDate}),0)

Thanks.

 

[chelseatech]

change the end of your formula to
totext(Year({?ReportDate}),0,"","&quot


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[synapsevampire]

The second set of quotes do nothing since the number of decimals is set to 0, the following will suffice.

totext(Year({?ReportDate}),0,"&quot

-k

 

[Dukester0122]

synapsevampire,

thanks that worked fine.