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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists