Listing members who joined in the past week?

[rawnet]

Hello All!!

I appreciate that this may be too simple to be a hack, as it doesn't really integrate with vBulletin - not sure. Basically, I'd like to just list all my members who have joined in the past week.

This is so I can include the info in my weekly newsletter, and point visitors towards a page which just lists those who joined in the past week.

I'm just confused as to what I should use in the WHERE clause of my query - can someone enlighten me? Not sure how I select records from exactly the last week?

Cheers,

Ross