Cant find the entry between Two dates even though the entry is present in the db

Please read Formatting code and log snippets in posts and update your sample document.

I suspect a type discrepancy between your query which is a Date and your data that looks like strings. The types and values must match.