i'm trying to extract a data based on 2 criteria.
date is not cooperating!
the supposed to be October 7, 2017 (10/7/2017)
is interpreted as July 10, 2017 (7/10/2017)
as you can see in the attached image, there is a record, yet it can't be found.
date is not cooperating!
the supposed to be October 7, 2017 (10/7/2017)
is interpreted as July 10, 2017 (7/10/2017)
Code:
Set rs = db.OpenRecordset("SELECT ID, Mon1, Tue1, Wed1, Thu1, Fri1, Sat1, Sun1, " & _
"Mon2, Tue2, Wed2, Thu2, Fri2, Sat2, Sun2 " & _
"FROM tbl1Timesheets " & _
"WHERE EmpNo = " & txtEmpNo & _
" AND StartDate = #" & txtStart & "#;")
as you can see in the attached image, there is a record, yet it can't be found.
Attachments
Last edited: