Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Thursday 7:57 pm
Add a reply View Replies (1)

Resolved List new users from last month

  1. carlos-bahiana
    carlos-bahiana
  2. Support
  3. Thursday, January 02 2020, 01:10 AM
Hi there

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.
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
try with this:
group_id IN (10,11) AND YEAR(registerdate) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)

AND MONTH(registerdate) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (1)
carlos-bahiana
carlos-bahiana Accepted Answer
Thank you so much, that did it!
  1. more than a month ago
  2. Support
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.