On Mon, Mar 24, 2003 at 03:23:50PM +1000, Steve Soars wrote:
> 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
Have you looked at the datediff() function?
<cfif datediff("d", killdate, todaydate) gt 0>
.
Check this out before using in production. I have a habit of getting these
date functions round the wrong way ;)
Cheers
Paul Haddon
Technical Services Manager
Formstar Print Technologies
---
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/
