Michael,

What order would you consider correct?

>I have the following SPT statement, but it's in the wrong order. I can't seem to get the ORDER BY syntax correct:
>
>

>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))
>

>
>TIA