I have an existing column that has "dates" in character format.
How can I alter my existing data frame coloumn so from: 2022-12 to 2022-12-01
- 2022-12 (Year-Month in class character) to 2022-12-01 (Year-Month-Day in class Date)
I have tired using the as.Date function but I have been unsuccessful.