Access Like vs Between Query Problem - Please HELP SOS

Hi All, How can I write this in a query - Criteria :

LIKE [Enter Date ?] = BETWEEN [Date_In] AND [Date_Out]

Please note that Date_In and Date_Out are fields and I want the query to ask me a date and then if it is within both in and out it will give me the record. I tried this sentence but Access is not accepting it. Am i making a mistake in pronouncing it ?. Thanks a lot

LIKE operator is relevant only with wildcard.

Create a field in query with expression:

DateValue: [Enter Date ?]

Then under this constructed field have criteria:

BETWEEN [Date_In] AND [Date_Out]