diffrent exchange rates in query colums
I have a problem with displaying different exchange rates (time difference) in query columns.
In the variable screen the user specify the year and period, the result will be two columns with different years and year to date period (e.g. (*** 2007.001 - 2007.006) (*** 2008.001 - 2008.006))
My problem now is the right translation of the two columns.
I created a customer exit with query due day and write the last of month and the right year back.
Then all values will be translated with exchange rate of 30.06.2008, but also 2007!!!
I hope someone have a solution.
Thank you in advance