How can i get data in a specific date range?

Hello everyone below have a query  i want to get data between these date range , but when i execute it return others rows which are not in this date range ??

 thanks in advance