Are you running CFMX 6.x? This sounds like the daylight saving time bug that was fixed with an updater.
DST changes at 2:00am on April 2 this year. Try a test of October when DST changes again. It would happen on the last Sunday in October. If that messes up, make sure you have the latest updaters for CFMX 6.x. M!ke -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 4:36 PM To: CF-Talk Subject: DateDiff HUH??? What the hell? I've got a form that has select fields for year, month and day for return and depart trip dates. For the following: <cfset dayAway = #DateDiff("D",#CreateDate(depYearSelect,depMonthSelect,depDaySelect)#,#C reateDate(retYearSelect,retMonthSelect,retDaySelect)#)#> If the depart date is April 1st (2005,04,01) And the Return date is April 10th (2005,04,10) dayAway = 8 days! This is also true for: depart (2005,04,02) return (2005,04,11) depart (2005,04,03) return (2005,04,12) ***BUT*** depart (2005,04,04) return (2005,04,13) depart (2005,04,05) return (2005,04,14) depart (2005,04,06) return (2005,04,15) .....and up: dayAway = 9 days! This *ONLY* happens with APRIL as the month. depart (2005,06,01) return (2005,06,10) correctly returns the number 9. WTF?? Ideas? This *is * driving me crazy!! -- ----------- Les Mizzell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
