Hi,

check first that the value that you are passing is a valid date before doing your search.

You can use:

if not isdate(expression) then
msgbox "Invalid date"
else
'code for search
end if

HTH,

Preeti