Converting text to date in ETL
I'm trying to convert a text into a date field in magic ETL, and I'm running into errors and unexpected outputs. Screenshots below.
When trying to just convert the (numbers as text) into dates, I'm receiving the error "An invalid date was found". When I conver that column first from text to numbers there's no issue, but then when I go to convert that new column to dates, I'm receiving all dates as 1/1/1970.
I've already accounted for non-numerical text fields in the filters previously.
Any help would be appreciated.
Structure of Data
Output of changing the above field to date
Output of changing field to number first then to date