Skip to Content
0
Former Member
Jan 25, 2011 at 09:25 PM

Currency conversion for specific day

594 Views

Hi guys,

I´m using the currency conversion for the day when the query is executed.

In the table TCURR are values for example like that:

1.1.2011 USD 1.3211 to 1 EUR

1.12.2010 USD 1.2222 to 1 EUR

1.11.2010 USD 1.11111 to 1 EUR

.

.

.

When I´m selecting in the query (selection mask) the month January 2011 the currency conversion is ok and the currency rate from 1.1.2011 is selected.

When I´m selecting in the query (selection mask) the month November 2010 also the currency rate from 1.1.2011 is selected. I expected the rate from 1.11.2010 because the November 2010 was selected in query selection mask.

How can I do the settings for the query that for each month wich was selected the corresponding currency rate from TCURR is selected correct?

Is there some easy solution?

Thank you in advance for your answers!

Regards