That would be tricky, I guess you could trunc the date field or something,
or use the format command.
But wouldn't you want the time piece in the comparison since 10/12/2004 at 3
PM is before 10/12/2004 at 5 PM? Excuse the stupid question just trying to
understand...
<http://intranet>
Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101
Office Phone 606.920.7447
Cell Phone 606.831.4590
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 1:27 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries
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]
