I'd do a dateCompare() or a dateDiff() rather than messing with the
dateFormat().  Something like: #iif( NOT dateCompare(i,
qrygetusers1.we_date), DE('checked'), DE('')#

HTH,
Bill
-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 17, 2001 6:22 AM
To: CF-Talk
Subject: IIF Help

Can someone Please help me with this one.

#iif("(dateformat(i, "mm-dd-yy")" eq "(dateformat(qrygetusers1.we_date,
"mm-dd-yy"))", de("checked"), de(""))#

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to