On 15 Oct 2001, at 15:01, Hug wrote:

> Let's suppose I have a SALES_DETAIL table with these records:
>
> Product_ID Date Price
> ACA13003 2001/09/14 145.00
> ACA13003 2001/09/23 155.00
> ACA13003 2001/10/06 152.00
>

I don't have a solution but a similar problem ....

Suppose we add another record

ACA13003 2001/10/31 162.50

Today Oct 15th we want the effective price, which should be the
one from 2001/10/06?

Paul
Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com