>

select avg(date)

>GIVING ERROE MSG (NON NUMERIC EXPRESSION).
>WHO CAN HELP ME?
>THANK YOU

Chaim,
This seems to work

SELECT AVG(<table>.date) FROM <database>!<table>

Is date the field name as that is a reserved word.
HTH