Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to convert values in AED to USD based on the daily rates,
Pls suggest...
Regards,
Joshua.
do you have any table or file where you maintain conversion rate????
If yes then write if condition
like if(currency_type='AED',value_field*conversion_rate,value_field)
Regards
Dear Prashant,
Thank you for ur suggestion.
Actually we dont have the conversion rate table.Is it possible to update daily with internet.
Regards,
Joshua.
chk below thread might help you
Regards,
Hi Joshua,
Try:
[Conversion Rates]:
LOAD [Emirati Dirham],
[1.00 AED],
[inv. 1.00 AED]
FROM
[http://www.x-rates.com/table/?from=AED&amount=1]
(html, codepage is 1252, embedded labels, table is @1);
Emirati Dirham | 1.00 AED | inv. 1.00 AED |
---|---|---|
British Pound | 0.208914 | 4.786650 |
Euro | 0.236136 | 4.234855 |
Swiss Franc | 0.259769 | 3.849578 |
US Dollar | 0.272252 | 3.673071 |
Australian Dollar | 0.343444 | 2.911681 |
Canadian Dollar | 0.344055 | 2.906509 |
Singapore Dollar | 0.372716 | 2.683007 |
Malaysian Ringgit | 1.166676 | 0.857136 |
Indian Rupee | 17.516009 | 0.057091 |
Japanese Yen | 30.513657 | 0.032772 |
Cheers
Andrew