There probably were empty or null dates.

>Jay,
>
>Try removing the asterisk in the COUNT()....
>
>HTH
>Dennis
>
>
>>UPDATE: Doh! I forgot the last condition in the ICASE.
>>
>>I'm getting an error "Cannot determine data type of the expression." on the SQL below.
>>

>>CLOSE DATABASES
>>
>>USE c:\fmsrun\prompt\EligAct IN 0
>>
>>m.DOSBegin = DATE() -30
>>m.DOSEnd = DATE()
>>
>>SELECT ;
>>	ICASE(;
>>		MONTH(DOSBegin)= 1,'Jan',;
>>		MONTH(DOSBegin)= 2,'Feb',;
>>		MONTH(DOSBegin)= 3,'Mar',;
>>		MONTH(DOSBegin)= 4,'Apr',;
>>		MONTH(DOSBegin)= 5,'May',;
>>		MONTH(DOSBegin)= 6,'Jun',;
>>		MONTH(DOSBegin)= 7,'Jul',;
>>		MONTH(DOSBegin)= 8,'Aug',;
>>		MONTH(DOSBegin)= 9,'Sep',;
>>		MONTH(DOSBegin)=10,'Oct',;
>>		MONTH(DOSBegin)=11,'Nov',;
>>		MONTH(DOSBegin)=12,'Dec') AS MonthName, ;
>>	COUNT(*) AS DOSCnt ;
>> FROM EligAct ;
>>	WHERE BETWEEN(EligAct.DOSBegin,m.DOSBegin,m.DOSEnd) ;
>>	GROUP BY MonthName ;
>>	INTO CURSOR ReportCursorSummary
>>
>>BROWSE LAST 
>>
>>CLOSE DATABASES
>>