Different character types of same column into date format


Could you please create a reprex to provide us with some of the data you are working with and what you are trying to do to it. A reprex consists of the minimal code and data needed to recreate the issue/question you're having. You can find instructions how to build and share one here:

My first idea would be to use the date formatting function on the strings like this

myData = data.frame(date = c("16/01/2020", "01/05/2020"))
myData$date = as.Date(myData$date, format = "%d/%m/%Y")

#> [1] "Date"
#> [1] "2020-01-16" "2020-05-01"

Created on 2020-09-29 by the reprex package (v0.3.0)