IntervalMatch (Extended syntax)

[#1]

I hope someone can help me with the command IntervalMatch.

I have salesorders in currency, I want to convert then to EURO's.

So I have a currency and a amount.

Also I have the count rate per currency with a date from / until.

Problem:

The USD currency come twice (orderline 2) because the rate has change from 1.25 till 1.29 per 1th april 2010.

The orderline has an orderdate from 15th february so only rate 1.25 must I have.

See the attachment.'Script IntervalMatch.txt'

I am curious wath the solution is for this problem.

Regards,

Alfred Hamers

[swuehl]

Try this:

INNER JOIN INTERVALMATCH (OrderDate, Val)

LOAD

          DateFrom,

          DateUntil,

          Val

resident RateData;