Praveen Maurya

Praveen Maurya

  • 1.9k
  • 146
  • 18.7k

Error in selection Datetimepicker date

May 31 2018 3:41 PM
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 
  1. 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')  
 
 

Answers (5)