npl77
asked on
SQL To Find Date Closest to Today's Date
Can someone give me some T-SQL to distingish between records and give me the record that has the date closest to Today's date?
sample data:
Employee ReportedDate
Nick 12/14/1977
Nick 08/16/1979
Nick 11/25/2005
Nick 11/25/2005
The T-SQL would return "Nick" the "11/25/2005" for this example
sample data:
Employee ReportedDate
Nick 12/14/1977
Nick 08/16/1979
Nick 11/25/2005
Nick 11/25/2005
The T-SQL would return "Nick" the "11/25/2005" for this example
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER