Access – Date Function causes Division b

I have two computers that exhibit this same problem and I don’t know how to solve it. The line of code is :

Set validrec = db.OpenRecordset(“SELECT ValidationRunDates.ValidationDate FROM ValidationRunDates WHERE (((ValidationRunDates.ValidationDate)=” & Date & “));”)

The error is Division by Zero, which makes NO sense to me in this context. We’ve even tried reloading Access thinking that one of the DLL files had become corrupt.

Any suggestions would be greatly appreciated!