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?
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.