Another solution from my experience, not a purist one but working: convert both variables to character, and with str_remove() make the formats identical. After that left_join works fine, and the variable can be converted back to date format.