Querying a date closest to today

[Explorer5]

How can i write a query that looks for the date that is closest to today, and
only returns one record? I dont want to do a date range because the date may be
in the past or future, and it may be the previous day, or 20 days out...
Thanks, Andrew Calvo

[mcsenow]

If you use MS SQL version 7 or later, you can try
SELECT TOP(1) FROM table WHERE datecolume < getdate()

[OldCFer]

You can use:

SELECT TOP 1 MIN(ABS(DATEDIFF(mi, SOMEDATE, GETDATE())))

then Order by
MIN(ABS(DATEDIFF(mi, SOMEDATE, GETDATE())))