I need to produce a montly listing of all new registered users from two specific groups. I'm experimenting with some Custom SQL WHERE queries, but never managed to get only entries from last month. This is the query I tried:
group_id IN (10,11) AND registerdate >= DATEADD(month, -1, @startOfCurrentMonth) AND registerdate < @startOfCurrentMonth
This brings an ampty list, but
group_id IN (10,11)
brings all register users, which is not what Iintended.