Need formula to show max date that is less than another date

[dazum]

I am using CR11.
I need a formula that lists only Assement Dates that are less than than the Case Status date.(see example below)

Group 1(Case ID)
Details Case Status Date Assesment Date
2-15-11 3-4-11
12-9-10
11-6-08
4-26-07

I would Assessment Date to show only if it is before 3-4-11.

 

[lbass]

Create a formula {@newdate} like this:

if {table.assessmentdate} < {table.casestatusdate} then
{table.assessmentdate} else
date(0,0,0)

Then you can go to report->selection formula->GROUP and enter:

{@newdate} = maximum({@newdate},{table.caseID})

-LB

 

[dazum]

Thanks lbass! That worked great. Thanks for your help and quick response!