Hi:
Here's what I am trying to do _- I am trying to get the price closest to the Trade date in the following table from a price table.
I have a table with the following data
Trades:
ID TradeDate TradePrice
1 1/25/2016 98
1 12/31/2015 97
And
Another table with the following
Price:
ID PriceDate Price
1 6/1/2015 84
1 1/5/2016 89
1 1/13/12016 95
1 1/23/2016 96
1 1/29/2016 92
The desired result is
ID TradeDate TradePrice Pricedate Price
1 1/25/2016 98 1/23/2016 96
1 12/31/2015 97 1/5/2016 89
Any help is greatly appreciated!!
Thanks In Advance