I have two different variables which I need to combine with date column. I am using left_join function. However, the date form in other variable is POSIxct form. How can I turn this to different form? It seems like it is now "2014-01-29 UTC"
I put on the other variable mutate(date=as.Date(substr(Date,1,10),format="%Y-%m-%d"))%>%