Serge;

I need the dates ascending instead of descending.

>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