Anniversarys within a given quarter

[Snookless]

Hello all,
Got a difficult one here (for me anyway), I am trying to creatre a report to show employees that have an anniversary date of 1,3 or 5 years within any specific quarter of the year, for example within the third quarter of this year (this current quarter) who has an anniversary of 1,3 or 5 years?
Using Crystal 8.5
Thank you

 

[synapsevampire]

An example of what you want the report to look like would help.

Create a formula akin to:

cdate(year(currentdate),month({Bob.Order Date}),day({Bob.Order Date}))

Group by the formula, and select The Section Will Be Printed For Each Quarter.

Drop the fields into the details.

Now in the record selection formula use something like:

datediff("y",{Bob.Order Date}, currentdate) in [1,3,5]

That should do it.

-k