The answer depends on your data. I will assume there is some form of a date in the database that is associated with your customer.
You then an apprpriate date function perhaps DATEADD in this case and create something like
Year(DateField) > = DATEADD("yy",-10,Date())
You may need to clean the syntax up but the logic is to look at the year part your date field and have it show everything greater than or equal to 10 years from today. The negative ten (-10) subtracts 10 years from current year
This would go in the Record Selection formula or in the Command object if v.8.5 supported them
From Crystal Help (Search Help)
Year function - extracts the year from a date and returns it as a Number. Year(x)
DateAdd has a number of possibilites.
Hope this helps.
Regards,
John W.
IP Logged
