How can i format date column with format "Sat Aug 16 2001" using R?

Question

I have a dataframe with a date column using a specific date pattern, where the format is "Sat Aug 15 1992", for example. I tried to use as.Date("Sat Aug 15 1992","%Y-%m-%d") but it returns only NA. How can I make R understand my column as a date?

score 1 · Answer 1 · answered Mar 15 '21 at 13:36

1

Try

as.Date("Sat Aug 15 1992",format="%Y-%m-%d")

answered Mar 15 '21 at 13:36

noah1400

49
4

score 1 · Accepted Answer · answered Mar 15 '21 at 13:37

1

Check ?strptime, you can use :

as.Date("Sat Aug 15 1992","%a %b %d %Y")
#[1] "1992-08-15"

answered Mar 15 '21 at 13:37

Ronak Shah

286,338
16
97
143

Thank you, you saved my morning. – Guilherme do Valle Mar 15 '21 at 13:39

How can i format date column with format "Sat Aug 16 2001" using R?

2 Answers2