>What is the most efficient way to find the last date or the latest date in a date fields.
>
>Calculate won't work on a date field will it?
>
>Calculate Max....
SELECT MAX(DateField) FROM MyTable INTO ARRAY aMaxDate
? aMaxDate[1]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.