do you use aim? im not sure i see whatcha mean.
if i put a date in there that is in our regular EST then i get the right time back.... that url explains it and shows that its fixed....at least i thought. let me check again... tw -----Original Message----- From: Johan Steenkamp [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 10:51 PM To: CF-Talk Subject: Re: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST Thanks Tony Well the bug is still there for all of us as far as I can tell. I get incorrect datediff() on my system even when setting it to US time zone and then using one date outside appropriate US region DST period and other date inside DST period. If the dates are both outside or inside the DST period then no problem no matter what machine time zone is. Regards Johan ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 22, 2003 2:07 PM Subject: RE: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST > actually... > > it was a bug that was fixed, fixed to help with dst in the states, so it > works > perfectly up here, however i would imagine adverse affects for you...not > good > since it doesnt accomodate both places...i had submitted a bug to mm > during > the redsky beta, and they validated it... > > http://www.navtrak.net/cfmxBug.cfm > > has some code, and the explanation of what i found, you will see > it...and > that is on a 6.1 server. > > try that code on your machine, and see what happens. > > tony > > -----Original Message----- > From: Johan Steenkamp [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 7:01 PM > To: CF-Talk > Subject: Re: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST > > > Hi Tony > > I have tracked it down - is a bug in 6.1 in my opinion. > > You did not see error as the problem occurs when one of the dates is in > DST > and the other is not in DST. The date range I gave has this situation > for NZ > time. > > For example if you system is set to say US Eastern time try 1 Jan 2003 > to > end April 2003 which has one date in daylight having and one not, and > you > should see the problem. > > Otherwise choose two dates that span your regional DST dates. > > Testing same on 6.0 = no problem so bug introduced in 6.1 > > Regards > > Johan > > > ----- Original Message ----- > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, August 22, 2003 10:25 AM > Subject: RE: DateDiff() broken in 6.1 (Bug?) > > > > johann.... > > > > 6.1 ent > > > > tony weeg > > uncertified advanced cold fusion developer > > tony at navtrak dot net > > www.navtrak.net > > office 410.548.2337 > > fax 410.860.2337 > > > > > > -----Original Message----- > > From: Johan Steenkamp [mailto:[EMAIL PROTECTED] > > Sent: Thursday, August 21, 2003 4:38 PM > > To: CF-Talk > > Subject: Re: DateDiff() broken in 6.1 (Bug?) > > > > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
