Inserting Date/Time into MS Access Database

[R_J]

Hi All

I am using Labview 8.0. I am able to write the Date in MS Access but i am not able to read it through Labview. In my case i have to read the data where Start Date=02/10/2007 and End Date= 23/10/2007. I am using this command -

SELECT*From Table_Name Where Date between '02/10/2007' AND '23/10/2007'   

but i am getting error -

Error -2147217887 occurred at Conn Execute.vi->Untitled 2.vi

Possible reason(s):
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: ODBC driver does not support the requested properties. in Conn Execute.vi->Untitled 2.vi

Please give suggestion to read the data.

regards

J

[sivamgr]

Try this,

SELECT*From Table_Name Where  datediff(day,Date_Field,convert(datetime,'01/01/2007',101))>=0

 and datediff(day,convert(datetime,'10/10/2007',101),Date_Field)>=0