When I run this command to check if the date columns are in the correct yyyy-mm-dd format
df1 <- df %>% mutate(date_created = lubridate::ymd(df$date_created) )
I get the following message 2117 failed to parse- which is great ( there are over 200,000 rows ) as some will be wrong BUT how do I know which ones have failed ?
cheers