I am trying to do currency conversion in HANA view
converting the currency column which hold all the currencies and target currency as GBP and method is Z3.
Conversion Date is the issue, if i set any fixed date then it is converting the currency values to GBP. There is no issue on fixed date. If i select any date column for conversion date then it is not converting.
How to fix this? i need to pass date column instead of fixed date.