Comparing dates

[mistaking]

Please help...

I have a query that prompts for 2 dates, then is supposed to retrieve all invoices between the 2 dates.
What expression do I need to use to make sure I get the desired result?
I cant compare the two dates using the > operator

 

[Idjit]

In the criteria row for the date field, type this:

Between [Enter beginning date] and [Enter ending date]