Dan, There is actually 48 seconds...
@Brad - I am not sure what you are trying to do, but you might consider doing the diff on seconds and converting it to the number of days, minutes seconds etc by calculating this. Plenty of examples how to turn seconds into mins, hours, days etc. On Thu, Apr 15, 2010 at 1:49 PM, Dan G. Switzer, II <dswit...@pengoworks.com > wrote: > > Brad, > > On Tuesday, April 13, 2010, Bradley Stone <b...@nb9m.com> wrote: > > > > All: > > > > Feeding DateDiff() dates which are more than 24 hours apart yields > minutes: > > > > <cfoutput> > > #DateDiff("n", "2010-04-08 19:41:36.0", "2010-04-12 19:10:34.0")# > > </cfoutput> > > > > Result: 5728 > > > > However, feeding DateDiff() dates which are LESS than 24 hours apart > yields nothing: > > > > <cfoutput> > > #DateDiff("n", "2010-04-08 19:34:47.0", "2010-04-08 19:35:35.0")# > > </cfoutput> > > > > Result: 0 > > There's only 13 seconds between those two dates, so zero is the > correct response. > > -Dan > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm