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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
