Date to Text - Formatting 1

[dunkyn]

I am trying to extract the year out of a date, and make it a text string, so I can add it to a text description.
I want 2007, not 2,007. When I change the date to a string, the "," appears.

CStr ((Year ({cot31203.Maturity Date})))

How do I remedy the formatting? I changed the formatting when it was a date, but as soon as it becomes a string, it adds the ",".

TIA - Crystal is new to me.

 

[lyanch]

totext(Year ({cot31203.Maturity Date}), "#&quot


Lisa

 

[dunkyn]

Thanks so much! What does the ('#') mean?

 

[TedLiu]

check crystal report help and indexed by totext, you will find it.

Ted