How to reformat dates to dd/mm/yyyy to yyyy

Question

Essentially, I just need to drop the extra info provided by the day and month, and only retain the year. My data is in the form of dd/mm/yyyy (so, 20/11/2001 for example) and I want to just retain the yyyy (so 2001).

This question and answer: R: How to remove the day from a date? have been somewhat helpful, but I have thousands of individual dates and so copying in the exact dates I need to change isn't going to work. Does anyone have any idea how I can do this??

Does this answer your question? [Extract year from date](https://stackoverflow.com/questions/36568070/extract-year-from-date) — Steve austin, Jan 13 '21 at 12:26
`library(data.table); year(as.Date(c("2020-06-01", "2021-01-10")))` — Roland, Jan 13 '21 at 12:26
In case it is a character you can use `sub`: `sub(".*/", "", YourDates)` or `format(as.Date(YourDates, format = "%d/%m/%Y"), "%Y")` — GKi, Jan 13 '21 at 12:29
Thank you both so much! This solved the problem, so I've reposted the code below! — Hannah Salamon, Jan 13 '21 at 12:31

score 1 · Answer 1 · edited Jan 14 '21 at 07:04

1

Convert to date class, then extract year using format:

format(as.Date(df1$Date, format="%d/%m/%Y"),"%Y")

edited Jan 14 '21 at 07:04

zx8754

52,746
12
114
209

answered Jan 13 '21 at 12:31

Hannah Salamon

31
2

How to reformat dates to dd/mm/yyyy to yyyy

1 Answers1