Finde hvor mange poster der er time for time

SQL = "Select Format(DateTime, 'dd-mm-yyyy hh') As CDato, Count(Format(DateTime, 'dd-mm-yyyy hh')) As RowCount From Statistik Where DateTime = #2000-01-01# Group By Format(DateTime, 'dd-mm-yyyy hh') Order By Format(DateTime, 'dd-mm-yyyy hh') Desc"

Jeg kan ikke rigtigt få den til at returnere noget. Men den laver ikke fejl.

Min kode:

<table background="images/front2.bmp"><tr><td><b>Time</td><td><b>Antal</td><td><b>Procent</td></tr>
<%

Set Hits = DataConn.Execute("Select Format(DateTime, 'dd-mm-yyyy hh') As CDato, Count(Format(DateTime, 'dd-mm-yyyy hh')) As RowCount From Statistik Where DateTime = #"&CDate(Dato)&"# Group By Format(DateTime, 'dd-mm-yyyy hh') Order By Format(DateTime, 'dd-mm-yyyy hh') Desc")

Do until Hits.EOF
If not Ialt = 0 Then
Procent = (hits("Rowcount") * 100) / IAlt
else
Procent = 0
end if
Procent = FormatNumber(procent,2)
Response.Write "<tr bgcolor=""white""><td>" & Hits("CDato") & "</td>"
Response.Write "<td align=""right"" width=""60"">" & hits("RowCount") & "</td><td align=""right"" width=""100"">" & Procent & "%<br><table cellpadding=""0"" cellspacing=""0"" width="""& FormatNumber(Procent,0) &""" height=""5"" bgcolor=""black""><td></td></table></td></tr>"
Hits.MoveNext
Loop
%>
</table>

Aha! Fik den til at funke med en between.

Tak for hjælpen Netro...

Velbekomme.