Posted by CK on 10/01/56 11:42

Good Morning,
I have a view that contains rate information, contractIDs, and effective
dates.
I need to select the rate info based on contractID and date.
I can provide a date and contractID, and I need to select the rate info for
that contract where the effective date is <= dateprovided.

I need the 1 record that is closest to that date.

I am thinking something with max() perhaps. Any ideas? The <= effective
date will return several rows, I just need the one closest to the date I
provide.

Thanks for any advice,
CK

[Back to original message]