Use CONVERT() to SELECT and GROUP BY the date portion of the StartDate code example

Example: How can I group by date time column without taking time into consideration

GROUP BY CAST(myDateTime AS DATE)