>I settled on the convert function: Convert(Char(8),DateField,1) works for the Group By clause. For the Select clause I use Max(DateField) because I want to return a date.

Thanks !!! ... you just saved me hours of work.