grouping by year(date)? 1

[obuspider]

I need to group my recordset by year(date). I created a formula to isolate the year, but when I group based on that formula, it changes my date to a number with a decimal. Is there a better way to do this or to fix my problem?

 

[kenhamady]

You can format the number without the decimal and commas, or you can use:

Totext(Year(Date) , 0 , '') Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com