search for: date12

Displaying 2 results from an estimated 2 matches for "date12".

Did you mean: date1
2017 Sep 24
0
"XLConnect" packages; Excel dates read incorrectly
Hi John, I was able to reproduce your problem in my environment. I modified the statement date11<-as.Date(a_col$date, format="%Y-%m-%d") to date11<-as.Date(as.POSIXlt(a_col$date),format="%Y-%m-%d") which then gives the output you would like to see (at least on my system) > date11 [1] "2004-01-01" "2004-01-02" "2004-01-05"
2017 Sep 24
3
"XLConnect" packages; Excel dates read incorrectly
Hi, Thank you for all your responses. For Eric, The files are attached. (I believe it was also attached in my first message) For David, Could you send me the link regarding possible solutions or a more comprehensive description of the problem? Thanks, John 2017-09-23 22:29 GMT-07:00 David Winsemius <dwinsemius at comcast.net>: > > > On Sep 23, 2017, at 6:30 AM,