I have a datatable with two columns - a date field (datetime) and currency field(string)
I need to get the max date from the datatable where the date is less than some derived date
and the Currency matches a currency field
strCurrency = "USD"
dBusDate = '06/01/2010'
In this example I need to get the max date less than dBusDate and currency = USD from the datatable