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