Cast character column to date column - mutate and as.Date

You could try using the dmy() function from the lubridate package. Then you would just do something like this:

tblvolumeDistribution %>%
  mutate(castedDate = lubridate::dmy(castedDate))
1 Like