Are you trying to do this in CF code or in your query. I would suggest using
the query for this if possible:
SELECT *
FROM tableName
WHERE dateField < NOW()
In your CF code you don't really need to use a dateformat function. CF is
able to do straight date comparisons and the datetime format that mysql uses
is perfect for use in CF:
<!--- set up a dummy variable to look like a mysql dateformat --->
<cfset thisDate = "2003-03-25 12:00:00">
<cfif thisDate EQ now()>
thisDate is right now
<cfelseif thisDate GT now()>
thisDate is in the future
<cfelse>
thisDate is in the past
</cfif>
Hth
Cheers
Mark
______________
Mark Stanton
Web Production
Gruden Pty Ltd
Tel: 9956 6388
Mob: 0410 458 201
Fax: 9956 8433
www.gruden.com
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
