>Sorry
>First, my real field name is 'testdate' (I used 'date' only for example).
>The main thing is that I coninue to get the error message!
I don't think that avg() will work on a date just a number.