I have raw data with the date given as
189901 which I want to be 1899-01-01 , 189902 which I want to be 1888-02-01 , 189912 which I want to be 1888-12-01
How to achieve this in R
Asked
Active
Viewed 31 times
0
-
`paste` 01 to the dates and then use `as.Date`, `as.Date(paste(189901, '01'), "%Y%m%d")` – Ronak Shah Dec 13 '19 at 03:39
1 Answers
0
date_nums <- paste(c("189901", "189902", "189912"), "01", sep = "")
date_format <- as.Date(paste(date_nums, "01"), format = "%Y%m%d")
date_format
[1] "1899-01-01" "1899-02-01" "1899-12-01"
Eugene Chong
- 1,466
- 4
- 15