Year() Function Problem 1

[MitchPitt]

When I try to format a date to get the Year, it will have 2/3/1997 turn into 1,997.00. How do I get rid of the Decimal and also the comma format so when I use the formula it will just have 1997?

 

[IdoMillet]

Hi Mitch,
---------------------------
Cstr(Year({your_date}),0,"&quot
---------------------------

The zero indicate zero decimals

The "" indicates no thousands separator.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[chelseatech]

I would use the ToText function directly

ToText({your_date}),"yyyy&quot

Seems a lot simpler and only uses one function. Editor and Publisher of Crystal Clear

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

 

[dgillz]

Year({DateField}) will return a number. All you need to do is format the number, no additional formulae required. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com