I have a field named TheDate with Format = dd-mm-yyyy and Default value =Date().
I created a query with criteria as under


Like "*" & [Enter Date : ] & "*"

When I run the query, the it asks for date input. After typing the date, it does not show any records of that date. Perhaps I have not put the criteria properly. Can someone help me how I should put the criteria?

All you need is [Enter Date] to search for a specific date.

You use the Like & * with strings

Thank you very much.