I am to use the MAX() function in an SQL statement. Keying on the maximum date in the PKGDATE field. But is not working, do anyone have any suggestions on how I can do this. See example below.

SELECT DISTINCT SUBSTR(pkgname,1,3), pkgdate, clientver FROM Pkgsrcvd INTO TABLE LAST_TRANSMITTED ;
WHERE MAX(PKGDATE) AND !EMPTY(clientver) ORDER BY 1


Thank You In Advance



Winfred Majors