"Doug Bell" <dug@bigpond wrote ...

It could be something to do with the strange way Americans write dates ie
mm/dd/yy
I am not sure if Excel holds dates in the same format as Access but in
Access SQL to get the date to work properly you have to format the criteria
in the non international format.

Try formating your search date
strCurrentDate=format(datSearchDate,"mm/dd/yyyy")

Could be better to try an unambiguous format e.g. this one usually
works for me with Jet:

Format$(dtmTest, "dd mmm yyyy")

Jamie.

--