Not tested, but how about something like this:

SELECT *;
   FROM MyTable;
   WHERE ABS (MyDate - {^ 2005/03/10}) =;
      (SELECT MIN (ABS (MyDate - {^ 2005/03/10})) FROM MyTable)

HTH

>I'm trying to write a query to return records from a table that are closest to a certain date. I'm not sure what the syntax should look like in my SQL select statement.