I have a query and I'm not sure how to limit the users by last login date. i only want to return the users who have logged in in the last week. Here's my query:
"SELECT `ID` FROM `Profiles` WHERE `DateLastLogin` < '[1WEEK]'"
WHERE DateLastLogin > ADDDATE(NOW(), INTERVAL -1 WEEK)