Q&A about the site for Drupal developers and administrators
select count(distinct displayname) mycount from users where creationdate > '2012-01-01'