I construct a 2 x 2 table in Excel which contains the following:

Date             Value 
12/31/2008    1.0

If I transfer this range to Rexcel with a put dataframe operation to a
variable x, then x$Date is displayed as
                         Date
1 2008-12-30 23:00:00

The datetime value is one hour less that it should be - i.e. it hasn't taken
US Daylight Saving Time into account.

My system locale is UTC-5 (Boston). I'm running R 2.10.1, RExcel 3.0.19,
Excel 2007 (32-bit), Windows 7 Ultimate (64-bit). 

Is there a way to adjust the locale for Rexcel so it converts the date
correctly?

-- 
View this message in context: 
http://n4.nabble.com/Rexcel-dataframe-import-adds-23-00-00-to-dates-tp1735089p1735089.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help@r-project.org 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.

Reply via email to