Where Condition not working for DATEs

Hi,

In my application search does'nt work for DATE but it works for numbers.

When i kept a response.write(strSQL) here is the output..

Not working for date---

SELECT ID,ProcessOrder,DateOfProduction,IBMNo,SAP,SapName,StorageBin FROM tblShelfData WHERE Plant=0 AND DateOfProduction LIKE '%10/10/2004%' ORDER BY ProcessOrder asc

follwing Works for number---

SELECT ID,ProcessOrder,DateOfProduction,IBMNo,SAP,SapName,StorageBin FROM tblShelfData WHERE Plant=0 AND SAP LIKE '%2000000907%' ORDER BY ProcessOrder asc



Any ideas?

Praveen

 

I think you can't use LIKE for Dates dude... Use >, < or = Only...

 

indian webmaster is quite right,
there you go :

SELECT * FROM DATE_SAMPLE 
WHERE SAMPLE_DATE >= '2003-04-09' 
AND SAMPLE_DATE <'2003-04-10'

Code (markup):