CREATE TABLE rc (id_pp int, dat_b date) SET STRICTDATE TO 0 && SET DATE GERMAN SET DATE AMERICAN &&USE IN query && SELECT rc ZAP IN rc * 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}) * 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}) *BROWSE SELECT id_pp,dat_b, COUNT(DISTINCT id_pp) AS countp FROM rc GROUP BY id_pp,dat_b