Hi Tony
Thanks for testing - can you confirm your test was on CF 6.1? If so was it
Standard or Enterprise version? My testing is on Standard.
It works on 6.0 for me but not 6.1
Noted I can get the correct result by adding 1 hour to the second date.
Displaying system getTimeZoneInfo() shows not difference between 6.0 or 6.1
systems so does not look like anything with localization/time.
regards
Johan
----- Original Message -----
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 3:36 PM
Subject: RE: DateDiff() broken in 6.1 (Bug?)
> here is what i get...
>
> 1. {ts '2003-05-01 00:00:00'} - {ts '2003-10-01 00:00:00'} = 153
> 2. {ts '2003-05-01 00:00:00'} - {ts '2003-10-02 00:00:00'} = 154
> 3. {ts '2003-05-01 00:00:00'} - {ts '2003-10-03 00:00:00'} = 155
> 4. {ts '2003-05-01 00:00:00'} - {ts '2003-10-04 00:00:00'} = 156
> 5. {ts '2003-05-01 00:00:00'} - {ts '2003-10-05 00:00:00'} = 157
> 6. {ts '2003-05-01 00:00:00'} - {ts '2003-10-06 00:00:00'} = 158
> 7. {ts '2003-05-01 00:00:00'} - {ts '2003-10-07 00:00:00'} = 159
> 8. {ts '2003-05-01 00:00:00'} - {ts '2003-10-08 00:00:00'} = 160
> 9. {ts '2003-05-01 00:00:00'} - {ts '2003-10-09 00:00:00'} = 161
> 10. {ts '2003-05-01 00:00:00'} - {ts '2003-10-10 00:00:00'} = 162
> 11. {ts '2003-05-01 00:00:00'} - {ts '2003-10-11 00:00:00'} = 163
> 12. {ts '2003-05-01 00:00:00'} - {ts '2003-10-12 00:00:00'} = 164
> 13. {ts '2003-05-01 00:00:00'} - {ts '2003-10-13 00:00:00'} = 165
> 14. {ts '2003-05-01 00:00:00'} - {ts '2003-10-14 00:00:00'} = 166
> 15. {ts '2003-05-01 00:00:00'} - {ts '2003-10-15 00:00:00'} = 167
> 16. {ts '2003-05-01 00:00:00'} - {ts '2003-10-16 00:00:00'} = 168
> 17. {ts '2003-05-01 00:00:00'} - {ts '2003-10-17 00:00:00'} = 169
> 18. {ts '2003-05-01 00:00:00'} - {ts '2003-10-18 00:00:00'} = 170
> 19. {ts '2003-05-01 00:00:00'} - {ts '2003-10-19 00:00:00'} = 171
> 20. {ts '2003-05-01 00:00:00'} - {ts '2003-10-20 00:00:00'} = 172
> 21. {ts '2003-05-01 00:00:00'} - {ts '2003-10-21 00:00:00'} = 173
> 22. {ts '2003-05-01 00:00:00'} - {ts '2003-10-22 00:00:00'} = 174
> 23. {ts '2003-05-01 00:00:00'} - {ts '2003-10-23 00:00:00'} = 175
> 24. {ts '2003-05-01 00:00:00'} - {ts '2003-10-24 00:00:00'} = 176
> 25. {ts '2003-05-01 00:00:00'} - {ts '2003-10-25 00:00:00'} = 177
> 26. {ts '2003-05-01 00:00:00'} - {ts '2003-10-26 00:00:00'} = 178
> 27. {ts '2003-05-01 00:00:00'} - {ts '2003-10-27 00:00:00'} = 179
> 28. {ts '2003-05-01 00:00:00'} - {ts '2003-10-28 00:00:00'} = 180
> 29. {ts '2003-05-01 00:00:00'} - {ts '2003-10-29 00:00:00'} = 181
> 30. {ts '2003-05-01 00:00:00'} - {ts '2003-10-30 00:00:00'} = 182
> 31. {ts '2003-05-01 00:00:00'} - {ts '2003-10-31 00:00:00'} = 183
>
> hth ... tony
>
> -----Original Message-----
> From: Johan Steenkamp [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 8:50 PM
> To: CF-Talk
> Subject: DateDiff() broken in 6.1 (Bug?)
>
>
> Can anyone else confirm that the datediff() function is broken in MX 6.1
> compared with 6.0?
>
> Simple test (code below) - output will show two consecutive dates with a
> difference of 157 days i.e:
> ...
> 156
> 157
> 157
> 158
> ...
>
> where it should be
> ...
> 156
> 157
> 158
> 159
> ...
>
> Problem not evident on 6.0 (Windows or Linux).
>
>
> <!--- test code --->
> <cfset year = 2003>
>
> <cfset date1 = createdatetime(year,5,1,0,0,0)>
>
> <cfloop index="i" from="1" to="31">
> <cfset date2 = createdatetime(year,10,i,0,0,0)>
> <cfoutput>#i#. #date1# - #date2# =
> #datediff("d",date1,date2)#</cfoutput><br>
> </cfloop>
>
>
> --------------------------------------------
> Johan Steenkamp
> www.assetnow.com
> --------------------------------------------
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
