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.