One year anniversary for members

[Morgain]

HM is both an offline and online community. At present we're creatinjg three types of members.
A small group of Elders I can handle manually as it's very small.
Newcomer members of a year or less, and the "middles"
Each to have its own title.

I don't see how to make the user title change to reflect that change around the one year membership completion. I thought Upgrades did that kind of thing but on closer inspection they don't.
Nor can I manually search on members on length of membership which seems strange.

What I'd really like is a notification that someone is completing their 1st year in the coming month. Then I could review them manually and decide if they have been active enough to upgrade them.

Any ideas on doing searches or getting notifications on this important anniversary?

 

[Jake Bunce]

Use this query to select all users who registered between the two specified dates:

SELECT user_id, username
FROM xf_user
WHERE register_date BETWEEN UNIX_TIMESTAMP('2011-11-06 00:00:00') AND UNIX_TIMESTAMP('2011-12-06 00:00:00')