Time Format Problem (1 Viewer)

[jmq]

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)

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.

 

[jmq]

Solved!

https://www.access-programmers.co.uk/forums/showthread.php?t=71319

Thank you!