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)
|11/2022|12/2022| = 7 character dates (excel)
some values have 7 characters and others have 10. You can I use
nchar() to build the logic to change the date to 10 characters and then to Format %y, %m, %d?