All dates are stored as floating point double precision numbers. How they're formatted just affects the way they look. If you have not manually altered your table field alignment and it is left aligned it is text and that would be an issue. If it's right aligned, it's numeric. My regional date setting is US format (mm/dd/yyyy) but a query will work using 10-17-2021 but Access will change the input to #10/17/2021# in query design.
the criteria on this field does not work with a date input like 10-06-2021
That tells us nothing. It means what, error raised, no results/wrong results, something else?
You could copy, compact and zip your db for analysis of the table and query involved as a way of getting a solution.
What is your regional setting for date format?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.