Howzabout the CF DateCompare() function..? Cheers, Adam
-----Original Message----- From: Steve Soars [mailto:[EMAIL PROTECTED] Sent: Monday, 24 March 2003 4:24 PM To: CFAussie Mailing List Subject: [cfaussie] time problems 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/ --- 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/
