Hi Tony You have to have one date outside DST period and one inside DST period from what I can see. Certainly if setting my server time to another zone I can replicate problem.
Have Windows Messenger not AIM Regards Johan ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 22, 2003 3:31 PM Subject: RE: DateDiff() broken in 6.1 (Bug?) - happens if dates span DST > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
