I have a dataset which has the date variable. The time stamp is attached to the date- that's how it is appears in the excel file as shown in the first screenshot.. When I import into R, it changes into another format as shown in the second screenshot. I tried
as.Date formula, but it is asking for origin. How can I convert this into proper date format?
data<-data %>% mutate(submission_date=as.Date(submission_date))