Hi, I have a big database where one-third of the data is in a different date format than the rest. I'll add an example table to show you.
| plot | observer | date | | 1 | K | 31012020 | | 2 | K | 07022020 | | 3 | B | 01282020 | | 4 | B | 01292020 | So I have two different date formats; the first is in d m y while the other one is in m d y. My question is how can I change all the date data into the same format? Preferably in dd/mm/yy. (31-01-2020) I know I could use: d$date <- as.Date(d$date, format = "%d%m%Y") d$date <- as.Date(d$date, format = "%m%d%Y") but I can only do one and then it doesn't work. Is there a way i can use the first line for the date of observer K and the other line for the date of observer B? Thanks [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.