[R] Working with date

jim holtman jholtman at gmail.com
Wed Dec 26 21:03:32 CET 2012


you can remove the leading zeros wirh the following regular expression;

 gsub("(^0|(/)0)", "\\2", format(asd, format = '%d/%m/%Y'))
[1] "3/1/2012"


On Wed, Dec 26, 2012 at 2:25 PM, Ron Michael <ron_michael70 at yahoo.com> wrote:
> Thanks Jim for your reply.
>
> However I want "3/1/2012" not "03/01/2012"
>
> Any idea ?
>
> Thanks
>
>
> ----- Original Message -----
> From: jim holtman <jholtman at gmail.com>
> To: Ron Michael <ron_michael70 at yahoo.com>
> Cc: "r-help at r-project.org" <r-help at r-project.org>
> Sent: Thursday, 27 December 2012 1:01 AM
> Subject: Re: [R] Working with date
>
> forgot you were asking for mdy format
>
>> # interchange day and month
>> format(asd, format = '%d/%m/%Y')
> [1] "03/01/2012"
>>
>
>
> On Wed, Dec 26, 2012 at 2:14 PM, jim holtman <jholtman at gmail.com> wrote:
>> try this:
>>
>>> asd <- as.Date("2012-01-03")
>>> asd
>> [1] "2012-01-03"
>>> format(asd, format = '%m/%d/%Y')
>> [1] "01/03/2012"
>>>
>>
>>
>>
>> On Wed, Dec 26, 2012 at 1:31 PM, Ron Michael <ron_michael70 at yahoo.com> wrote:
>>> asd <- as.Date("2012-01-03")
>>
>>
>>
>> --
>> Jim Holtman
>> Data Munger Guru
>>
>> What is the problem that you are trying to solve?
>> Tell me what you want to do, not how you want to do it.
>
>
>
> --
> Jim Holtman
> Data Munger Guru
>
> What is the problem that you are trying to solve?
> Tell me what you want to do, not how you want to do it.
>



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.




More information about the R-help mailing list