The e-date service i’m running has no statistics on the average age of it’s members. This is something I feel is needed and so I made my own.  This query will handle the leap year. Replace [COLUMN] with the field with birthdate and [TABLE] with the table name.

SELECT EXTRACT( YEAR
FROM (
FROM_DAYS( DATEDIFF( NOW( ) , [COLUMN]) ) ) )
 +0 AS age
FROM [TABLE]

This will give you the age of all users and if you just need the average age use the following query.

SELECT AVG( EXTRACT( YEAR
FROM (
FROM_DAYS( DATEDIFF( NOW( ) , [COLUMN]) ) ) )
) +0 AS age
FROM [TABLE]

This is something that i’ve came across alot of times and I think it’s about time I wrote a blog post on this. It’s a verry easy fix but just a tip. Use a policy if you have the ability. This is for Windows XP

In regedit change the following key.
HKEY_LOCAL_MACHINE / Software / Microsoft / Windows / Current Version / Explorer / DocFolderPaths
There is a key with the path to the folder. Change that and reboot.

That should do the trick!