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

bkdadomo · 2022-11-15T18:01:52+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Date

Magic ETL

Accepted answers

All comments

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of