artsheiko
Databricks Employee
Databricks Employee

The fact that you get records for >= 2020-01-31 doesn't mean you should get something for < 2021-01-01 as well.

Let's say the set contains the date 2099-01-01. Then, when applying the first condition, you will see the corresponding row, but applying the second one you will get "Query returned no results" which makes sense.