>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only