Thanks for the fast reply! That did allow me to run the code without the error, however it was grouping the same day each month together. I tweaked it a bit with the following which seems to work correctly.SELECT AuthorName, DATENAME(mm, CreateDT) AS Month, DATENAME(dd, CreateDT) AS Day, DATENAME(yyyy, CreateDT) AS Year, COUNT(*) AS Total FROM [FM].[dbo].[WORKOBJ] GROUP BY AuthorName, DATENAME(mm, CreateDT), DATENAME(dd, CreateDT), DATENAME(yyyy, CreateDT)