How can I retrieve with a query the first and the last date of a data base?
Printable View
How can I retrieve with a query the first and the last date of a data base?
Assuming you mean Table(s) and/or Queries when you say DataBase ..
SELECT MAX(DateField) FROM Table
.. should get the latest date. Use MIN instead of MAX for the earliest. You can make the FROM (and associated WHERE) clauses as complex as you can with any other query.
thank you!
To Admin: Consider the thread closed.
G.