Error in selection Datetimepicker date

Question

I want to filter my database using date time picker but when I am selecting date between 01-05-2018 and 01-06-2018 it shows only 01-05-2018 value please check is there any error

 

My SQL query is 

SELECT DATE, ITEM_NAME, QTY, UNIT_SALE_PRICE, UNIT_PURCHASE_PRICE, TOTAL_SALE_PRICE, TOTAL_PURCHASE_PRICE, DIFFERENCE FROM      PROFIT_LOSS WHERE (DATE BETWEEN '01-05-2018' AND '01-06-2018')