Sign Up Now!Log In
ian maclauchlan 6/24/2015 12:30:14 PM

SQL code to look at Exchange Rates

Im in the process of creating a suite of reports on Contracts admin and have a query regarding Exchange Rates.

Part of the suite will be reporting our contract's in GBP, so a contract stated in GP as  USD with a bill date of 28/03/2015 I need the Exch rate as at 01/03/2015 GBP-USD

or a contract in SGD with a Bill Date of 12/11/2014 will look up  Exch Rate as at 01/11/2014 for GBP-SGD


I hope that this makes sense as I have not got a clue how to do it!!


Many thanks 

Version: GP 2013
Section: SQL Scripts, SSRS