Hi, I am fairly new to writing crystal reports and I am stuck on an item. I work for a membership organization and we're trying to track anniversary date of our members (those who have joined 0-3 years ago, 3-5 years ago, 5-10 years ago, and 10+ years ago).
I want the report to display join.dates in the columns listed above: 0-3 years, 3-5 years, 5-10 years, and 10+ years in comparison to CurrentDate. I have set up the inital report and want to use four running totals for the above date ranges, but create a condition formula to calculate the date ranges in comparison to CurrentDate.
Any ideas on what these formulas might look like? I've been racking my brain all afternoon and haven't come up with anything that will work.
Any help would be greatly appreciated. Thank you.
IP Logged
