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
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部