[R] Changing string to date

Brian Diggs diggsb at ohsu.edu
Fri Aug 30 20:15:26 CEST 2013


On 8/30/2013 3:36 AM, Uwe Ligges wrote:
>
>
> On 30.08.2013 11:59, Christofer Bogaso wrote:
>> Hello again,
>>
>> I have a string which I need to put in some legitimate date format.
>>
>> My string is: "MAY-14"
>>
>> And output format would be "05/01/2014", this should be of Date class,
>> so that I can make some sensible calculation with it.
>>
>> I have tried this without any success:
>>
>>> as.Date("MAY-14", format = "%b-%y")
>> [1] NA
>>
>
>
> You must have set an English locale (to recognize the word May as a
> month) and you have to add a day.

You can use the yearmon class from the zoo package as an intermediary to 
get around having to explicitly add a day

library("zoo")
as.Date(as.yearmon("MAY-14", format="%b-%y"))

gives

 > as.Date(as.yearmon("MAY-14", format="%b-%y"))
[1] "2014-05-01"

> Best,
> Uwe Ligges
>
>
>
>>
>> Can somebody help me how I can achieve that?
>>
>> Thanks and regards,
>>
>> ______________________________________________
>> R-help at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>


-- 
Brian S. Diggs, PhD
Senior Research Associate, Department of Surgery
Oregon Health & Science University



More information about the R-help mailing list