Hi Cathi,

I can't include .ToString() in the quary, because the "DateIn" field is a date type.
I get a conversion error if I add it.


>Hi Ahmad,
>
>Try changing the select statement to the following:
>
>

>Dim myAttendanceSql As String = "SELECT * FROM AN_CheckInOut WHERE Mem_EmpID = '" & Trim(Me.txtID.Text) & "' AND DateIn = '" & Date.Today.ToString() & "'"
>

>
>Also keep in mind that SQL Server uses DateTime and not just Date. Therefore your DateIn expression must match both the date portion and the time portion exactly.
>
>>Dear All,
>>
>>Am I missing somthing with this SQL statment:
>>

>>Dim myAttendanceSql As String = "SELECT * FROM AN_CheckInOut WHERE Mem_EmpID = '" & Trim(Me.txtID.Text) & "' AND DateIn = " & Date.Today
>>Dim myAttendanceDA As New SqlDataAdapter(myAttendanceSql, myConn.oAdoNetSql_Conn)
>>Dim myAttendanceCB As New SqlCommandBuilder(myAttendanceDA)
>>

>>
>>It return 0 rows if I included the date in the query. and no errors!
>>
>>I am using SQL2000 MSDE.
>>
>>Thanks for the help.