Converting string to date with as.Date in R

Asked Nov 03 '20 at 21:16

Active Nov 03 '20 at 21:16

Viewed 39 times

I am trying to convert a character string to date in R.

string <- "August2018"

as.Date(x = string, format = "%B%Y")

The following code gives me only NA :(

From the documentation, %B is the full month name in the current locale and %Y is Year with century (4 digit year).

I also tried to set my locale to "en_US.UTF-8" with the code: Sys.getlocale (category = "LC_ALL"). This did not help either.

Can somebody please help me what I am doing wrong?

asked Nov 03 '20 at 21:16

1

You can paste a day and then use `as.Date(paste0(string, '01'), format = '%B%Y%d')#[1] "2018-08-01"` or with lubridate `myd(string, truncated = 1)# [1] "2018-08-01"` – akrun Nov 03 '20 at 21:18
1

An alternative is to use the `zoo` package and zoo::as.yearmon(string). – tester Nov 03 '20 at 21:22
Thank you very much for the solutions and sorry for the late answer! – Sterbinszky Gábor Feb 18 '21 at 07:38

0 Answers0