SELECT COUNT(0) FROM QB_User WHERE CONVERT(VARCHAR,CAST('2007-09-07' AS DATETIME),112) = CONVERT(VARCHAR,CreateDate,112)