比较在访问中保存的日期与今天不工作的日期

I'm trying to run a query, as part of VBA code, which looks at all the records containing today's date in a date field and writes them to a record set. The following SQL statement doesn't work however. It doesn't return any records, even though the DateEntered field definetely has records with today's date.I'm trying to run a query, as part of VBA code,