Well, here's something that works, but I'm not sure it's performance is going to be...

what makes a condition = true? 
looking at your query 6 records from the 01/03/2018...

I don't get the "4" . As far as I get it it should be...