I need to do a query with count distinct and IF, but the results always are 0. What I need to do, is count the different users from a table in different months, using IF.
My individual query, for one month is this:

 SELECT 
 COUNT(DISTINCT(idUsers)) AS num_usuarios
 FROM table01
 WHERE date1='201207'

But I need to get the results by different months in the same query. What I'm trying to do is this:

SELECT 
IF(date1=(201207), count(distinct(idUsers)), 0) as user30,
IF(fecha1=(201206), count(distinct(idUsers)), 0) as user60,
IF(fecha1=(201205), count(distinct(idUsers)), 0) as user90,
IF(fecha1=(201204), count(distinct(idUsers)), 0) as user120,
IF(fecha1=(201203), count(distinct(idUsers)), 0) as user150
FROM table01

But the all the results are always 0.