>Here it is:
>
>SELECT temp.mnemonic, ata, name, class, type, status, CNT(*) FROM temp ;
>INTO TABLE assignee_temp ;
>WHERE group = gcGroup AND dept = gcDept ;
>AND BETWEEN(assign_date,gdStartDate,gdEndDate) ;
>GROUP BY 1,2,3
>
Could it be that the BETWEEN() function is INCLUSIVE?
-Mike