I am in desperate need of help. I have spent about 2 weeks trying to do this and failed miserably.
All I need to do is convert a column into a recognisable date format.
The data is imported as text into a column called Source.Name. The date is shown as 020922.CSV (this is the name of the file imported). I have tried using Delimiter to split .CSV from 020922(uk date), but I get an error inside the column when converting ABC to date. I have also tried splitting 020922 into separate day, month and year columns and changing format to number, and adding leading zeros. This also doesn’t work.
Any idea how I can make a date column out of my Source.Name column?