Greatest Date From a Parameter

[bombplayer]

If I have a list of dates grouped by a ID number, how do I find the greatest date prior to a inputted parameter.

SalesID.Date(1/1/2001)
SalesID.Date(2/1/2001)
SalesID.Date(3/1/2001)

Parameter input 2/15/2001

How do I return the 2/1 record?

 

[bombplayer]

And without a select statement because I need all records on the report

 

[kenhamady]

If you need all of the dates to appear, how do you want to identify your target record? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[bombplayer]

Thanks for responding Ken. Actually the target record will be a indicator for another formula so that when the parameter date has been hit, it will use the date prior to the parameter date to flag a running total.

 

[kenhamady]

Write a formula:

If {date} < parameter
then {date}

and then you can use a condition that says:

{Date} = Maximum ({Formula},{Group}) Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[bombplayer]

Thanks Ken