i have a table that contains dates and rates, i want to create a query which returns the rate corresponding to todays date or the closest date in the past
(i know how to say select where date = a certain date but how do i do the above???)
any ideas????
