Sum of all instances of dates more than 30 days old
Hello all, I'm attempting to sum all of the instances of dates that are more than 30 days older than the current date to determine which users of my app are no longer active. Below is my beast mode code: SUM(CASE WHEN DATEDIFF( CURDATE(),Max(`Last Sign In`)) > 30 THEN 1 ELSE 0 end) However, ever time I run this command it…