Problem with dates in access

Hi i am making a loans system and i am trying to allow a search function in my program which allows the user to search for loans due back on a certain date.

the loan details(including the due date) are stored in a microsoft access database.

at the moment i prompt my user to type in a date in the format yyyy-mm-dd, and then i convert that to a java.sql.Date with the valueOf() method.

However when i then go and try and find this date among the records in my database with a query, it doesnt show up. Does access have its own silly date system or something? It isnt giving me any error messages, just not returning any results even though i know the date exists in there.

any help is greatly appreciated,

thanks

[749 byte] By [boblettoj99a] at [2007-11-27 9:35:27]