How do I convert a string to a date within Magic ETL?

bkdadomo

I've seen questions asked about converting string to date, and answers were all given to use Beast Mode or add a separate field. Is there a way to do this in Magic ETL? I want to just have all the cleaning done in one place but can't find a way to do this in either version of Magic ETL.

MichelleH

@bkdadomo Yes, depending on the format of the dates you can either use the Alter Columns tile to change the datatype of the field or use the STR_TO_DATE function in a formula tile.