Thanks!

>>Hi All:
>>
>>How do you retrieve the record that has the latest date from a table? I thought you use the MAX function but the following code gives me all the records from the table.
>>
>>Thanks,
>>
>>Yossi
>>
>>

>>SELECT MAX(fp_dlvdat), fp_prccorn, fp_prcsoy ;
>>	FROM feedpric ;
>>	GROUP BY fp_prccorn, fp_prcsoy ;
>>	INTO CURSOR result	
>>

>
>

>select fp_dlvdat, fp_prccorn, fp_prcsoy ;
>	FROM feedpric t1 ;
>  where fp_dlvdat == ;
>  (SELECT MAX(fp_dlvdat);
>	FROM feedpric t2 ;
>	where t1.fp_prccorn == t2.fp_prccorn and t1.fp_prcsoy == t2.fp_prcsoy) ;
>	INTO CURSOR result	
>

>
>PS: http://www.foxyclasses.com/sql_date.htm
>
>Cetin