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.