VB Code:
  1. SELECT A.referenceno,  B.datetime
  2. FROM defectiveitem AS A, exportorder AS B, customer AS C
  3. WHERE A.exportorderid = B.id AND A.customerid = C.id AND C.name = 'SLT'
  4. AND
  5. (B.datetime >= '20/04/2001' AND B.datetime <= '21/04/2001')
  6. ORDER BY B.id

When I run this query I don’t get the dates that are equal to '21/04/2001' even though there are data like that



i am using sql server 2000