Sorry if I'm misunderstanding you, but it sounds like all you need to do is run a cfquery around the date with a maxrow of 1...
<cfquery name="maxrec" datasource="dsn" maxrows="1">
SELECT id
FROM table
ORDER BY date_in_question DESC
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
