[cfaussie] time problems

[Steve Soars]

Hi guys,   We have a field (datetime) in a database (mySQL) that outputs like yyyy-mm-dd hh:mm:ss    What we are trying to do is evaluate whether the date in the database is less than now   <cfif #dateformat(killDate, "yyyy-mm-dd")# LT #dateformat(todayDate, "yyyy-mm-dd")#>   Can anyone suggest how this can be achieved Steve Soars www.i-redlands.net Interactive Redlands Shop 2 Cleveland Town Square Cnr Queen & Bloomfield Sts Cleveland QLD 4163 [p] 07 3821-5800 [f] 07 3821-5811 "what we do in life echoes an eternity" --- 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/