Select record with most recent date...

Dodger

10-17-2002, 09:06 PM

I should know this...but don't...

Please help.

TIA.

Spookster

10-17-2002, 10:01 PM

You could

SELECT * FROM tablename ORDER BY datefield DESC LIMIT 1

Dodger

10-18-2002, 07:35 AM

duh! that's so easy...

Thanks! ;)