I think this will work in VFP9, but I haven't tested it...

SELECT * ;

FROM table ;

WHERE dateField = ( ;

SELECT MAX(date) ;

FROM table t2 ;

WHERE dateField <= ldRequired)

On Thu, Mar 12, 2009 at 14:58, KAM.covad <a_gmail_noSpam@kenmcginnis.com> wrote:

> I have a table with a date field: dDate and thousands of records.

>

> The dates are scattered over time including the future. I need to find the record with the max date that is =< required date.

>

> How would you do this with sql select and also with Locate?