>SELECT (cast(datepart(mm,time) as varchar)+'/'+datename(dd,time)+'/'+datename(yyyy,time)) AS DayField, >COUNT(CondoDir) AS Hits FROM wwRequestLog >WHERE UPPER(CondoDir) LIKE 'FRANKLIN' >AND DATEDIFF(day, time, getdate()) < 14 >GROUP BY (cast(datepart(mm,time) as varchar)+'/'+datename(dd,time)+'/'+datename(yyyy,time)) >>