Excellent point - thanks! I need to display the date, so I may need to keep the date text field unless I can concatenate from the new field.

>Michael,
>
>I think this should work for you, it does a direct conversion to varchar:
>
>SELECT Convert(varchar(10), time, 101) AS DayField,
>COUNT(CondoDir) AS Hits FROM wwRequestLog
>WHERE UPPER(CondoDir) LIKE 'FRANKLIN'
>AND DATEDIFF(day, time, getdate()) < 14
>GROUP BY time
>ORDER BY time
>
>If you use ORDER BY on a varchar field converted from datetime, the rows may not end up sorted correctly, for example "01/01/1998" will be returned before "01/02/1997".
>
>Roman
>
>
>>>You should be able to add GROUP BY and ORDER BY DayField into you SELECT statement.
>>>
>>>Stephen
>>>
>>It doesn't allow me to use DayField, but it does work if I use:
>>ORDER BY (cast(datepart(mm,time) as varchar)+'/'+datename(dd,time)+'/'+datename(yyyy,time))
>>
>>After the GROUP BY
>>
>>I thought I tried this before. I must have dropped a paren.
>>
>>Thanks!
>>
>>>
>>>>>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