I'm having some challenge converting a newly created column in r to date format

Using a date object and pulling out components such as day of week, month, year, week of year or quarter of year has advantages over dealing with string processing. But, if you want help, post a reprex so it will be possible to see what’s going on.