Getting latest date from db.

[Kylie]

I've created a database that contains a date field in one of the tables. When a record is created in the table the date is inserted.

I'm trying to retrieve the date of the last entry from the database.
I've tried "SELECT Max(date) FROM tableName" with no luck.

😕 Can anybody point me in the right direction?

Thanks
Kylie

[maxpup979]

I don't suppose that you have a sequence that you also enter...😉 That would be too easy....🙂

You could try select datefield from table order by datefield desc limit 1