I'm trying to write a formula to compare two date fields.  Date field A will be updated periodically, so there will be several records in the field.  I want to see if Date B is in the range of the current Date A.  BTW, this is in a subreport.

Example: 

Date A:  1/1/12
              3/1/12
              5/6/12

Date B is 2/14/12 so I only want to compare it to the data for the data that was current at the time, Date A = 1/1/12

If Date B was 4/15/12, then it would compare to Date A = 3/1/12 because it was the most current data at that time.

Any help is appreciated.

lockwelle, Thank you for your response.  I'm not only a newbie to CR, but programming in general.  I don't know what a stored proc is.  I also don't understand what you mean by "top n report."  What I have done is group the data in the subreport by Date A.  I've written a formula:

if {Date B} >={Date A} then true else false

This works in looking at the most current date.  The problem now is, that it shows all dates that are greater than {Date A} in the detail section. Example, if Date B is 4/16/12, it shows in the detail section for the first and second groups.  I only want it to display dates that are >= the group header, but < the next group header.

I've tried {Date B} <(next{Date A}) then true, but it sees  the next value as the group header, not the true next value.  I've also tried maximum with the same results.