>>>anyone,
>>>how do you write an SQL statement to be passed to sqlserver7 to group by date only without the time in datetime interfering in the process ?
>>
>>select < aggregate >, < aggregate > from MyTable group by Convert(Char(10),MyDatetimefield,101)
thanks larry
Use things, not people. Love people, not things