>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