Thanks!

>>Hi All:
>>
>>Can you help me with this code? What's wrong with this syntax?
>>
>>

>>SET STRICTDATE TO 0
>>
>>SELECT MAX(flocknum) FROM ;
>>(SELECT SUBSTR(fm_flcode,5,4) flocknum ;
>>FROM flckmast ;
>>WHERE fm_hatched <= {4/1/07} ;
>>AND fm_hatched >= {3/1/07} ;
>>) ;
>>INTO CURSOR test
>>

>>
>>Thanks,
>>
>>Yossi
>
>You forgot to alias subquery. But you don't need a subquery, and use clearer expressions for dates:
>

>SELECT max(SUBSTR(fm_flcode,5,4)) ;
>  FROM flckmast ;
> WHERE fm_hatched between date(2007,3,1) and date(2007,4,1) ;
>INTO CURSOR test
>

>Cetin