>
> i want to this ; select avg(datefield) from ... but what?
>

Well, one possible answer would be...
select avg(datefield) from datetable;

Care to be more specific with your question?

Sasha