Hello,
I have following format of dates in CSV file, which I want to change to 10 character date, format %y, %m, %d.
|04/27/2023|04/27/2023| = 10 chatater dates (excel)
|04/28/2023|04/28/2023|
|11/2022|12/2022| = 7 character dates (excel)
|01/2023|01/2023|
some values have 7 characters and others have 10. You can I use dplyr::case_when()
and nchar()
to build the logic to change the date to 10 characters and then to Format %y, %m, %d?
Thank you.