Bumping for relevance. We have a rather large community and being able to search for members by birth date criteria would be immensely useful in recognizing Birthdays in our monthly newsletter. Any word on a development?
In case anyone else might be looking, here's the SQL;
select * from xf_user_profile where dob_month = 12 and dob_day = 01;
select username, dob_day from xf_user
inner join xf_user_profile on xf_user_profile.user_id = xf_user.user_id
inner join xf_user_option on xf_user_option.user_id = xf_user.user_id
where dob_month = 10 and is_banned = 0 and user_state = 'valid' and show_dob_year = 1
order by dob_day asc;