I have those days too

I did get it to work like this

SELECT DATEADD(day, 0 , DATEDIFF(day, 0, creationdate)), COUNT(*)

FROM tblUsers

GROUP BY DATEADD(day, 0 , DATEDIFF(day, 0, creationdate))

ORDER BY DATEADD(day, 0...

Like This?

SELECT DATEADD(day, 0 , DATEDIFF(day, 0, creationdate)), COUNT(*)

FROM tblUsers

GROUP BY DATEADD(day, 0 , DATEDIFF(day, 0, creationdate))

ORDER BY DATEDIFF(day, 0, creationdate)

It generates another error (below)

Server: Msg 144, Level 15, State...

oops,

I made a mistake with my last post.

I generate this error when running the following commands

SELECT DATEADD(day, 0 , DATEDIFF(day, 0, creationdate)), COUNT(*)

FROM tblUsers

GROUP BY DATEDIFF(day, 0, creationdate)

ORDER BY DATEDIFF(day,...

Thank you kindly for all the help

It worked perfectly!

Rick