Posted By

pauliehaha on 03/10/09


Tagged

aspnet


Versions (?)

ASP.NET Membership Provider - Registered Users Active Within the Past [Month]


 / Published in: SQL
 

  1. SELECT COUNT(1) FROM aspnet_Users
  2. WHERE DATEDIFF(MONTH, LastActivityDate, getdate()) <= 1

Report this snippet  

You need to login to post a comment.