Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
INNER JOIN INTERVALMATCH (OrderDate, Val)
LOAD
DateFrom,
DateUntil,
Val
resident RateData;