I am currently importing data where the date is set as YYYYMMDD with no space between it. Is there a way to convert it to MM/DD/YYYY? Trying to do this for an entire column of dynamic data.
There are no spaces between the numbers and they read as 20220513.
There are no spaces between the numbers and they read as 20220513.