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
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
