I'm trying to update this query and return a column with the date/month/year along with the count of how many records are in each day.
SubmitDate datatype is smalldatetime
Part of the problem is that the smalldatetime also includes also includes hour/minutes/seconds.
SELECT COUNT(SubmitDate) AS CountDate
GROUP BY DATEADD(dd, 0, DATEDIFF(dd, 0, SubmitDate))