select (rows desired)
from tableselect
where abs( todays_date - col_date) = min( abs( todays_date - col_date));
SORT OF <LOL>, I'm not sure how to find that particular row, but is how you find the minimum difference from todays date.
Mark Tessier wrote:
> Hi,
>
> My question is hopefully a simple one: If I have several rows, each containing a date field, and I want to select the row that has the date closest to today's date, what would be the syntax for carrying that out.
>