> I am using RODBC to collect data from an ODBC connection to an MS Access > Database. Everything seems to be working well except datetimes between > March 12, 2006 02:00 and 02:59 get moved one hour forward. This does not > seem to be happening with Excel connecting to the same connection. March 12 > seems a bit early for Daylight savings time. What am I doing wrong?
In 2007, the US moved daylight savings to March 11 instead of the more traditional first weekend in April. It continues to November 4, a week later than before. Google "daylight savings 2007" for lots of background. Some MS programs did not make the switch until April 1, therefore my calendars doubled up continuing appointments. >From your experience, it looks like some programs are retroactively misapplying the change to 2006. ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.