How do I remove the comma and period in my formula? 1

[mn20]

i have a formula where i display the month(in words e.g. October) and the year (in number e.g. 2001) so i concat them both like this..
"OCTOBER " + ToText(Year{MyTable.Date}). the result of this formula is "OCTOBER 2,001.00", which is irritating!! i want it to come out like "OCTOBER 2001". pls reply if you have an idea how to do it.

thanks a lot!

 

[crazy99]

the following syntax may not be absolutely correct but you
need to had a ,0 after the date field to stop the decimal point and a ,"" to stop the comma. play with the following
and see what you get.

OCTOBER " + ToText((Year{MyTable.Date},0,"&quot.


Ken

 

[crazy99]

I think the exact syntax is:

"OCTOBER, " + ToText((Year{MyTable.Date}),0,"&quot.