Grouping by a Derived Date Formula 1

[Bella6]

I am on Crystal 8.5, and trying to create a report which groups by the age of a record.

If the record is 36 months old, I would like to group the check dates (not distinct) by 3, 6, 9, 12...36 months. In order to do this it looks like I need to create some sort of formula which calculates the age of the record and then be able to group by that.

Can anyone help me?

 

[synapsevampire]

Try something like:

if datediff("m",{table.field},currentdate) < 4 then
1
if datediff("m",{table.field},currentdate) < 7 then
2
if datediff("m",{table.field},currentdate) < 10 then
3
etc...

Make sure thaqt you have an open ended qualifier at thye end, such as:

if datediff("m",{table.field},currentdate) > 39 then
9999

You might also group by Quarters without using a formula if that suits your requirement, change the group options for the date to Quarter.

-k

 

[Bella6]

Thanks so much - it looks like your suggestion is working!
SG