Re: [R] "XLConnect" packages; Excel dates read incorrectly

2017-09-23 Thread John
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

Re: [R] gsDesign Pocock & OBF boundary

2017-09-23 Thread array chip via R-help
Sorry for messed up text. Here it goes again: I am learning to use the gsDesign package. I have a question about Pocock and OBF boundary. As far as I can understand, these 2 boundaries require equal spacing between interim analyses (maybe this is not correct?). But looks like I can still use gsDe

Re: [R] "XLConnect" packages; Excel dates read incorrectly

2017-09-23 Thread David Winsemius
> 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

Re: [R] "XLConnect" packages; Excel dates read incorrectly

2017-09-23 Thread Eric Berger
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

Re: [R] "XLConnect" packages; Excel dates read incorrectly

2017-09-23 Thread Jim Lemon
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