Minimum date

[DiegoMarcet]

Hi, I'm just starting using Crystal Reports 8.5 and I've found myself in a problem when I wanted to get a single record from a recordset that complies a condition where the date is the minimum in a range entered as parameters.
I cannot use the Minimum function since this error appears:
"The function cannot be used because it must be evaluated later"

Any suggestions?
The formula I'm using is:
{?Begin_Date} <= Minimum ({SOLD.DATE}) and {SOLD.DATE} <= {?End_Date}

Thanks

 

[mbarron]

A summary operation (such as minimum) of one of your fields is evaluated towards the end of the gathering and evaluation of data.

If you want to see the the earliest record that was returned, your formula field would:
minimum({SOLD.DATE})

Mike
If you're not part of the solution, you're part of the precipitate.