Thanks!
-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 1:30 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries
Or if you want all the records for the max month (not just the max date)
SELECT *
FROM table
WHERE month(DateCol) = (SELECT month(MAX(DateCol)) FROM Table) AND
year(DateCol) = (SELECT year(MAX(DateCol)) FROM
Table)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
