[R] as.Date with characters error

[Liz Hare]

Oh! Thank you so much! Sorry to have bothered everyone with this!

Liz


On 7/30/2013 12:16 PM, arun wrote:
> Hi,
> Did you checked after removing "e" from "formate"?
>
> ortho$test.dat <- as.Date(ortho$xray.date, formate="%d-%b-%y")
>
> A.K.
>
>
> ----- Original Message -----
> From: Liz Hare <doggene at earthlink.net>
> To: r-help at r-project.org
> Cc:
> Sent: Tuesday, July 30, 2013 12:00 PM
> Subject: [R] as.Date with characters error
>
> Hello,
>
> I'm trying to convert dates in the format dd-mmm-yy using as.Date.
> I have two columns like this, and it works on one but not on the other.
>
>> options(stringsAsFactors=FALSE)
>> ortho <- read.csv("test1.csv", header=TRUE, nrows=10)
>> ortho
>      DogID BirthDate xray.date
> 1  11877 23-Aug-87 15-Feb-88
> 2  11877 23-Aug-87 15-Feb-88
> 3   3599 21-Feb-87 21-Feb-88
> 4   3599 21-Feb-87 21-Feb-88
> 5   3599 21-Feb-87 21-Feb-88
> 6   3599 21-Feb-87 21-Feb-88
> 7   3599 21-Feb-87 21-Feb-88
> 8   9563 29-Jun-87 29-Jun-88
> 9   9563 29-Jun-87 29-Jun-88
> 10  9563 29-Jun-87 29-Jun-88
>> ortho$bdat <- as.Date(ortho$BirthDate, format="%d-%b-%y")
>> ortho$bdat
>    [1] "1987-08-23" "1987-08-23" "1987-02-21" "1987-02-21" "1987-02-21"
>    [6] "1987-02-21" "1987-02-21" "1987-06-29" "1987-06-29" "1987-06-29"
>> ortho$test.dat <- as.Date(ortho$xray.date, formate="%d-%b-%y")
> Error in charToDate(x) :
>     character string is not in a standard unambiguous format
>> sessionInfo()
> R version 3.0.1 (2013-05-16)
> Platform: x86_64-w64-mingw32/x64 (64-bit)
>
> locale:
> [1] LC_COLLATE=English_United States.1252
> [2] LC_CTYPE=English_United States.1252
> [3] LC_MONETARY=English_United States.1252
> [4] LC_NUMERIC=C
> [5] LC_TIME=English_United States.1252
>
> attached base packages:
> [1] stats     graphics  grDevices utils     datasets  methods   base
>>
>
> Does anyone have a guess about what's going on? I've googled for this
> error but haven't found any where the problem is with this type of
> conversion.
>
> Thanks,
> Liz
>