RE: SQL: Selecting Max Date Entries

[Bryan F. Hogan]

Thanks Ian, but how do I get it to ignore the time portion?

-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 1:21 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

SELECT *
FROM table
WHERE DateCol = (SELECT MAX(DateCol) FROM Table)

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---