Re: [R] Compiling date

2008-09-10 Thread Megh Dal
] Compiling date To: David Scott [EMAIL PROTECTED] Cc: Dr Eberhard W Lisse [EMAIL PROTECTED], Megh Dal [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Tuesday, September 9, 2008, 11:37 PM Is this Month-Day or Day-Month or a mixture of both? I still think using the Format - Cell - Date will work much

Re: [R] Compiling date

2008-09-10 Thread Charilaos Skiadas
] Subject: Re: [R] Compiling date To: David Scott [EMAIL PROTECTED] Cc: Dr Eberhard W Lisse [EMAIL PROTECTED], Megh Dal [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Tuesday, September 9, 2008, 11:37 PM Is this Month-Day or Day-Month or a mixture of both? I still think using the Format - Cell - Date

[R] Compiling date

2008-09-09 Thread Megh Dal
Hi, I have following kind of dataset (all are dates) in my Excel sheet. 09/08/08 09/05/08 09/04/08 09/02/08 09/01/08 29/08/2008 28/08/2008 27/08/2008 26/08/2008 25/08/2008 22/08/2008 21/08/2008 20/08/2008 18/08/2008 14/08/2008 13/08/2008 08/12/08 08/11/08 08/08/08 08/07/08 However I want to use

Re: [R] Compiling date

2008-09-09 Thread David Scott
On Mon, 8 Sep 2008, Megh Dal wrote: Hi, I have following kind of dataset (all are dates) in my Excel sheet. 09/08/08 09/05/08 09/04/08 09/02/08 09/01/08 29/08/2008 28/08/2008 27/08/2008 26/08/2008 25/08/2008 22/08/2008 21/08/2008 20/08/2008 18/08/2008 14/08/2008 13/08/2008 08/12/08 08/11/08

Re: [R] Compiling date

2008-09-09 Thread Henrique Dallazuanna
Try this: strptime(x, ifelse(nchar(x) == 8, '%d/%m/%y', '%d/%m/%Y')) On Tue, Sep 9, 2008 at 3:48 AM, Megh Dal [EMAIL PROTECTED] wrote: Hi, I have following kind of dataset (all are dates) in my Excel sheet. 09/08/08 09/05/08 09/04/08 09/02/08 09/01/08 29/08/2008 28/08/2008

Re: [R] Compiling date

2008-09-09 Thread Dr Eberhard Lisse
Why not Format - Cell in Excell? el on 9/9/08 1:03 PM Henrique Dallazuanna said the following: Try this: strptime(x, ifelse(nchar(x) == 8, '%d/%m/%y', '%d/%m/%Y')) On Tue, Sep 9, 2008 at 3:48 AM, Megh Dal [EMAIL PROTECTED] wrote: Hi, I have following kind of dataset (all are dates)

Re: [R] Compiling date

2008-09-09 Thread stephen sefick
this is day month year? look at chron or maybe the easiest is to use excel to change the format On Tue, Sep 9, 2008 at 7:12 AM, Dr Eberhard Lisse [EMAIL PROTECTED] wrote: Why not Format - Cell in Excell? el on 9/9/08 1:03 PM Henrique Dallazuanna said the following: Try this: strptime(x,

Re: [R] Compiling date

2008-09-09 Thread Dr Eberhard W Lisse
Is this Month-Day or Day-Month or a mixture of both? I still think using the Format - Cell - Date will work much better... el On 09 Sep 2008, at 11:21 , David Scott wrote: On Mon, 8 Sep 2008, Megh Dal wrote: Hi, I have following kind of dataset (all are dates) in my Excel sheet.