Text Date fix please..

[bmcauliffe2]

I hate the 'should be simple' ones that I really can't figure out.
I have a formula that has to display the year in text using ToText. Everything runs fine except I get the thousand separator in the middle of the year - 2,003 !

I bet it's simple but the help file in CR9 didn't do it for me. Can someone please help me out by modifying below :


'YEAR ' + ToText (Year ({Appt.StartDate}),0)

Thanks guys

Barrie

 

[bmcauliffe2]

Blooming 'Eck !! Just found it... ALWAYS THE WAY !!

For others searching :

ToText (({Appt.StartDate}),"yyyy&quot