Go4Expert - View Single Post - How to use date as a condition in where clause of access Sql

nadunalexander

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

nadunalexander Go4Expert Member
17Apr2007,11:35
	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