VB Code:
SELECT A.referenceno, B.datetime FROM defectiveitem AS A, exportorder AS B, customer AS C WHERE A.exportorderid = B.id AND A.customerid = C.id AND C.name = 'SLT' AND (B.datetime >= '20/04/2001' AND B.datetime <= '21/04/2001') 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




Reply With Quote