] 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
]
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
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
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
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
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)
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,
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.
8 matches
Mail list logo