Since you're seeking a match to an exact date why use the "floor" function? Just do : WHERE ( MyTableName.TradeDate=#Date Literal Here#);

Or if it's inexact the date (i.e. the lastmost time ) do something like:

SELECT TOP 1 Fieldsgohere ... FROM MyTable WHERE (MyTable.Table_Date=#Date Literal Here#) ORDER BY Table_Date DESC;