How to change from character to date format?

Question

For my dataset, the Date variable has dates in the format of this example: 19-Feb-03 I want to change the above character format dates in the column to a Date format. (As I have to do time series analysis later on)

I tried using the as.Date() method but it didn't work.

You can use `lubridate::dmy()` or you can specify a format string (assuming your locale is English) `as.Date(your_data$your_column, format = "%d-%b-%y")`. The format string keys are documented at `?strftime`. — Gregor Thomas, Dec 01 '22 at 14:30

score 1 · Answer 1 · answered Dec 01 '22 at 14:33

1

x <- '19-Feb-03'

lubridate::ymd(x)

"2019-02-03"

answered Dec 01 '22 at 14:33

Vinícius Félix

8,448
6
16
32

score 1 · Answer 2 · answered Dec 01 '22 at 14:34

1

Not sure whether 19 is year or day. You can try lubridate package

x<-"19-Feb-03"

library(lubridate)

ymd(x)
dmy(x)

answered Dec 01 '22 at 14:34

chris jude

467
3
8

How to change from character to date format?

2 Answers2