Get Closest date to Today

If you want to display the closes date of a lets say a Task to todays date here is what you will need to do:

SELECT TOP 1 
 
Task.Date 
 
FROM Task 
ORDER BY ABS(DateDiff(dd, Task.Date, GETDATE())) ASC;