Forum Discussion
Syndicate_Admin
Administrator
AdministratorChanging text formatting to date
Good afternoon, I have a problem transforming a column that is in text format to date throws me error, what I do is replace the word Annual with empty and try to take 2018 as a date, from now on than...
James-Harpin
Resolver IV
Resolver IVHello Syndicate_Admin ,
You would need to remove the text to convert this column to a Date data type, you can do this by removing 'Anual' from the column or if you want to keep the text you could split the column by Deliminator "space" to have one column with the text and one column with the year value.
When converting the column to Date you will get the format '01/01/2018' you can then change the format to 'YYYY' if you wish.
Syndicate_AdminThe problem is that when I remove the Annual and pass it to type of Data: Date throws me error in all