>> isn't 'm' a month? D'oh!
You're spot on mate, thanks, Rob -----Original Message----- From: t.o. [mailto:[EMAIL PROTECTED] Sent: 24 July 2007 10:29 To: CF-Talk Subject: AW: Date Comparison isn't 'm' a month? try with 'n' T. > -----Ursprüngliche Nachricht----- > Von: Robert Rawlins - Think Blue > [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 24. Juli 2007 11:16 > An: CF-Talk > Betreff: Date Comparison > > Guys, > > > > I'm trying to evaluate a date against now() to try and see if > the date is more than 5 minutes old, I'm sure I've used this > method before but for some reason I'm struggling to get it working. > > > > <cfif LOCAL.qMyQuery.DateTime LT > dateadd('m', -5, now()) > > > Date is older than 5 minutes. > > <cfelse> > > Date is within the last 5 minutes. > > </cfif> > > > > However this doesn't appear to work, it always displays the > 'Date is within the last 5 minutes.' Even when it's not J > > > > Any ideas? > > > > Thanks guys, > > > > Rob > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
