Convert string to date using vb with access as database

I want to convert a string variable called, strfl to a date using vb. I am using the codes shown below. The database is msaccess. The following code throws an error when the code, 'rstDelete.MoveFirst' is executed.
Error message : "Either BOF or EOF is true........".
But there is a value for hdate in the table called holiday which is equal to "20-09-05".
So, the problem has to be with conversion of string to date which is in the part of the code, "hdate = #" & (strfl) & "#"
Can anyone please help me by showing the proper string to date conversion that works with ms access?

Make sure your date string is in the same locale as your access db, i.e., mm/dd/yyyy. Next, try using / instead of - as a seperator, and use a 4 digit year. The acceptable date string formats for Access are shown in the Access online help, take a look there and make sure you're using a valid date string.

The error message indicates your query doesn't return any records, try it in access itself and verity that the query string works.

Thank you Doug. I have put the year in the 4 digit format and it works. In the code, I am assuming everything to be from the year 2000 onwards. I am using vb 6.0 and ms access installed from Office XP 2003.