Currency Conversion NOT on day basys

[m_baroja]

Hi!

I read posts as this one: Currency Conversion

But my problem goes a step further. My conversion table is not created on a day by day conversion basys. I have the exchange rate of some days only (let's say once a week for example), and what I need to do is to convert my billing amount using the exchange rate of the first date before my billing date.

Can somehow the standard Currency Conversion be adapted into this? Has anyone faced something like this?

Thanks!!

[maxgro · Accepted solution]

If I understand, I think you should add all the missing dates

There is an example (and the script too) here

How to populate a sparsely populated field

[m_baroja]

You understood perfectly and that's what I needed!

Thanks maxgro!