Hi Eric,
Thank you for your message! It does work in my system!!
I follow you by typing it:
date11<-as.Date(as.POSIXlt(a_col$date),format="%Y-%m-%d")
Then I typed it:
date12<-as.Date(a_col$date, format="%Y-%m-%d")
date12 yields exactly the same results as date11.
Then my system
FYI: Most files you might attach to an email sent to the mailing list will not
transmitted to us due to virus propagation policies of the mailing list (they
are removed see the Posting Guide). The best method for sharing binary
files is to to put them on a website like Dropbox or Google Driv
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"
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:0
> On Sep 23, 2017, at 6:30 AM, Eric Berger wrote:
>
> Jim,
> I don't see how that link could be related to John's issue. Symptoms
> related to your link involve discrepancies of four years whereas John is
> seeing discrepancies of one day.
>
The MS Excel starting point was off by one day. R do
Jim,
I don't see how that link could be related to John's issue. Symptoms
related to your link involve discrepancies of four years whereas John is
seeing discrepancies of one day.
John,
I do not see any attached files.
Regards
On Sat, Sep 23, 2017 at 1:30 PM, Jim Lemon wrote:
> Hi John,
> It c
Hi John,
It could be due to this:
https://support.microsoft.com/en-au/help/214330/differences-between-the-1900-and-the-1904-date-system-in-excel
Jim
On Sat, Sep 23, 2017 at 1:04 PM, John wrote:
> Hi,
>
>I tried to read xlsx files by "XLConnect" packages, but the dates are
> one day earlier
7 matches
Mail list logo
