Happy to help if you can create some sort of proper reprex (FAQ: How to do a minimal reproducible example ( reprex ) for beginners) for this. Lots of people also turn to lubridate to deal with dates specifically https://lubridate.tidyverse.org/ .