How to use date as a condition in where clause of access Sql
 

sqlStr1 = "SELECT * FROM sold WHERE dateOfSold=" & "3/29/2007"

I used this statement to retrive all the data they have value 3/29/2007 in the field of dateOfSold. When i try this statement this return empty record set. dateOfSold field is in access table sales. fieldtype is date/time. plese help me

Re: How to use date as a condition in where clause of access Sql
 

SELECT * FROM sold WHERE dateOfSold=#1/1/2006#

Re: How to use date as a condition in where clause of access Sql
 

Thank you, for ur reply. I it is very usiful to me.

Re: How to use date as a condition in where clause of access Sql
 

This code was very much helpful i just modified it as :

Adodc1.RecordSource = "SELECT * FROM cm1 WHERE dt>=#1/1/2011 02:00:00 AM# AND dt<=#4/1/2011 02:00:00 PM#"

for searching a database using VB !

please let me know if there is a way to accept input from the user in a text box and use thm instead of the constant values that i have used