What is the type of your Date column? If it is not the MongoDB "Date" datatype, then comparison will likely happen as strings instead of dates.

Is the result different if you run the query from the MongoDB shell?

If the result is not different if you run the query from the MongoDB shell, the problem is with MongoDB or your understanding of it, and not related to Perl.