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
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site