Ted,

So the MAX() SQL function is taking precedence over MAX() the VFP

function. I get it.

Okay, try this:

SELECT EVALUATE([MAX(lbilled,lbilled2,lbilled3,attbdate,patbdate)]) AS

MaxDate...

Bill Anderson

Ted Roche wrote:

>Bill: the MAX() keyword, when used in a SELECT-SQL statement calculates the

>maximum value of column and will only accept a single field argument.

>Anthony nailed it, by using a User Defined Function to do the calculation.

>

>

>