Trying to get count of all records per week from october to current.
this info will be used for a chart.
I have tried
SELECT COUNT(*) AS weekcount
WHERE (DateEntered BETWEEN CONVERT(DATETIME, '2004-10-18 00:00:00', 102) AND CONVERT(DATETIME, '2004-10-22 00:00:00', 102))
but that does not give me the resultset that I am searching for.
I am trying to return values as
and so on.
can anyone help figure this out.