>Okaaaayyy?
>you use
>

>>  * Using this code - no bug  
>>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-02})      
>>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
>>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-02})      
><pre>
>but
><pre>
>> * Using this code - bug  
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.01.2010})   
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.01.2010})   
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.01.2010})   
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.01.2010})   
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.02.2010})   
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (1,{01.02.2010})   
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.02.2010})   
>> *!*	INSERT INTO rc(id_pp,dat_b) VALUES (2,{01.02.2010})  
>

>
>the upper is all one date, the lower not
>
>if you use something like
>

>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-01})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-01-01})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-01})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-01-01})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-02-01})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (1,{^2010-02-01})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-02-01})      
>      INSERT INTO rc(id_pp,dat_b) VALUES (2,{^2010-02-01})      
>

>it happens with your format too.
>
>Problem seems to be within COUNT(DISTINCT ..) of a field grouped and datetime in the group rather then in the datetime format
>
>Agnes

I see, didn't notice the difference. It is still a bug, but probably not very important.