I' have problems doing a query into our product register.

I have two tables

VVARPF contains ProductInformation
VVVARE = ProductNumber
VVTEK = ProductDescription

VVPRPF contains PriceChanges
VPVARE = ProductNumber
VPDATE = ChangedDate
VPPRICE = ProductPrice

I need to lookup the price on the product at the current time. The VVPRPF register can contain prospective pricechanges used for future campaigns etc. That means I can't select the largest date.