Ahh!! I'm not thinking clearly, numeric differences in day number is what I want.
-----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 12:00 PM To: CF-Talk Subject: Re: datediff problem What is wrong with your results? DateDiff counts blocks of 24 hours not numeric differences in day number. Is that your problem? I find this counter-intuitive myself. ----- Original Message ----- From: "John McCosker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 10:50 PM Subject: datediff problem > Greetings, > > I am experiencing a problem with datediff function for extracting the day as > an integer, > > in my query I am outputting the results to test it and as you can see > datediff is returning the wrong result, it starts off ok then goes pair > shaped, > > <cfloop query="test" ....> > <cfoutput>#DATEDIFF("d",dt,now())#, #dt#<br></cfoutput> > </cfloop> > > ----RESULT------------ > > 1, 2002-04-23 10:20:00 > 1, 2002-04-23 09:35:00 > 1, 2002-04-23 08:05:00 > 1, 2002-04-23 07:05:00 > 1, 2002-04-23 06:21:00 > 1, 2002-04-23 05:36:00 > 1, 2002-04-22 22:51:00 > 1, 2002-04-22 22:06:00 > 1, 2002-04-22 21:21:00 > 1, 2002-04-22 20:36:00 > 1, 2002-04-22 19:52:00 > 1, 2002-04-22 19:07:00 > 1, 2002-04-22 17:52:00 > 1, 2002-04-22 16:37:00 > 1, 2002-04-22 15:52:00 > 1, 2002-04-22 15:07:00 > 1, 2002-04-22 13:38:00 > 1, 2002-04-22 12:37:00 > 2, 2002-04-22 11:08:00 > 2, 2002-04-22 10:08:00 > 4, 2002-04-20 10:58:00 > 4, 2002-04-19 22:58:00 > 4, 2002-04-19 19:57:00 > 4, 2002-04-19 15:57:00 > 4, 2002-04-19 12:57:00 > 5, 2002-04-19 09:57:00 > 5, 2002-04-18 19:12:00 > 5, 2002-04-18 18:12:00 > 5, 2002-04-18 17:27:00 > 6, 2002-04-18 11:27:00 > 6, 2002-04-17 19:25:00 > 6, 2002-04-17 14:24:00 > 7, 2002-04-17 11:24:00 > 7, 2002-04-17 04:23:00 > 7, 2002-04-17 01:23:00 > 7, 2002-04-16 21:22:00 > 7, 2002-04-16 17:22:00 > 7, 2002-04-16 13:22:00 > 11, 2002-04-12 18:32:00 > 11, 2002-04-12 17:47:00 > 11, 2002-04-12 16:49:00 > 11, 2002-04-12 14:03:00 > 11, 2002-04-12 13:18:00 > 11, 2002-04-12 12:33:00 > 12, 2002-04-12 11:33:00 > > has anyone come accross this problem before, > > respectfully, > > J > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
