The problem is start_time
is not in an unambiguous format, you need to specify the date format when converting it to date
class.
all_trips$date <- as.Date(all_trips$start_time, format = "%m/%d/%y")
Note: Next time please provide a proper REPRoducible EXample (reprex) illustrating your issue.