promotions wrong result

[josef]

I am trying to promote group "Users Awaiting Email Confirmation" to "(COPPA) Users Awaiting Moderation"

I am trying to do that for new registerd who registered in the last 30 days only

I am using 30 days and less than option in usergroups >promotions but every time i found greater than is the one choosen

as result all old memebers promoted to the new group which is wrong
i want only who registered in the last 30 days only

is there SQL Query to do that

[Zachery]

Why are you trying to rpmote users awaiting confirmation into the Moderation usergroup?

[josef]

most of them has registered by " hotmail email " and I found all registered who has hotmail account in their files can't receive activation email from my site, I don't know why, so I want to override this problem by promote them to moderation group so I can review the nickname if it is applicable or not

[Zachery]

Why not just check them? Or better yet fix the problem with hotmail?

[josef]

I have hundreds of them, it is not easy to check them one by one , the point that there are a bug in promotion procedures as less than doesn't work correctly

[Zachery]

LEss than only works for reputation.

[josef]

any SQL to do that?