Luciano Evaristo passes along a cool tip on how to get an average from a datetime field:
To workaround this, just change the SQL statement to SELECT CAST(AVG(CAST(MyTable.MyDateTimeField AS float)) AS datetime) FROM MyTable and things will work properly.
Cool tip!