You cannot compare date field 'dat' with character strings ("01/01/2005") AND ("31/12/2005"). They have to be the date constants or variables.

>i change it but i get error message
>Operator/operand type mismatch
>

>SELECT divi, mac1, ;
>	SUM(IIF(MONTH(dat)=1 AND typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m1_m, ;
>	SUM(IIF(MONTH(dat)=1 AND typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m1_a, ;	
>	SUM(IIF(MONTH(dat)=2 AND typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m2_m, ;
>	SUM(IIF(MONTH(dat)=2 AND typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m2_a ;	
>FROM table1 ;
>WHERE dat BETWEEN ("01/01/2005") AND ("31/12/2005") ;
>GROUP BY 1,2
>? m1_m,m1_a
>? m2_m,m2_a
>
>