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
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
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
