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,