ODBC SQL help need to filter out records by date

Dear SQL gurus, please help me with the code. I am transferring data to Excel from Navision via C/ODBC and need to filter records with the most recent day. Example: SSN Effective Date Amount 11111 01/01/2002 500.00 11111 07/10/2002 550.00 11111 01/01/2003 600.00 22222 700.00 22222 02/02/2003 750.00 I need to have in my Excel spreadsheet: SSN Effective Date Amount 11111 01/01/2003 600.00 22222 02/02/2003 750.00 Please note that Effective Date could be blank (which transfers as 1/0/1900 to my Excel) Thank you.