--- In IBObjects@yahoogroups.com, "Ed Dressel" <Dressel@...> wrote:

>
> I have a table with a date field. I need to get a value from the
> record with the maximum date--but the date can not be greater then

today.

I've got this:

select NeededValue from MyTable
where DateValue =
(select Max(DateValue) from MyTable where DateValue <=
Current_Timestamp)

I would prefer to get the Rate_ID field value, rather the the
Rate_Date field value (Rate_Date is a float). Is that possible?

Thanks
Ed Dressel