View Full Version : SOLVED: Find start and end date
banavas
08-04-2004, 05:04 AM
How can I retrieve with a query the first and the last date of a data base?
TonyJollans
08-04-2004, 05:12 AM
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.
banavas
08-04-2004, 05:42 AM
thank you!
To Admin: Consider the thread closed.
G.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.