Cool Idea/Question About Demographic Add-ons

[BigSash]

This may be ridiculous, forgive me if it is or this already exists.

My goal/idea is to have a way to extract demographic summaries about the customers in my store. At the very least to get average age based on DOB.

Does anyone know of an add-on that does this?

Does anyone know of a way to export the info I would need to compute the avg age without having to look at each customer record to transcribe the DOB?

Thanks!

[hugo13]

use a sql-statement like

SELECT AVG((YEAR(CURDATE())-YEAR(customers_dob)) - (RIGHT(CURDATE(),5)<RIGHT(customers_dob,5))) AS age 
FROM zen_customers WHERE customers_dob > 0 

OR

SELECT AVG(DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(customers_dob)), '%Y')+0) AS age
 FROM zen_customers WHERE customers_dob > 0; 

MYSQL::http://dev.mysql.com/doc/refman/5.0/...culations.html