>>>Does anyone know how to group a result set on just the date portion of a datetime column using SQL pass-through?
>>
>>Just select one more column: datepart as date(datetime field) and group on this column.
>>
>>Vlad
>
>The DatePart function in MS SQL server doesn't allow you to return the entire date portion. I would have to concatenate the year, month and day portions and I'm hoping to avoid that.

I don't know MSSQL. Are you using VFP? How do you access the SQL database? Via ODBC?

If yes, you should be able to use date( your_datetime_field) which should return the date part of datetime field.

Vlad