I am completely stumped as to why this query results in no matches:
When there are 3 records in the database table TIMECLOCK that have the DATEOFPUNCH as 12-29-2013. This query has always worked perfectly fine until today is the first time it has a 2014 date... Any ideas?PHP Code:
SELECT STYLIST FROM TIMECLOCK WHERE DATEOFPUNCH <= '01-04-2014' AND DATEOFPUNCH >= '12-29-2013'
It is to find all STYLIST in TIMECLOCK table with a DATEOFPUNCH between 12-29-2013 -> 01-04-2014