Nearest max date before a specified one

Hi,

I am trying to create an SQL statement which would return to me the maximum
date before a specified date. I was able to get a list of records with dates
prior to the one I enter but not the last one. Can anyone help? Thanks.

SELECT tblDates.dEntryDate
FROM R tblDates
WHERE (((tblDates.dEntryDate)<CDate('1.1.2005')));

Frank



.