Datefield recognized as text

Is there a way to view the faulty date which is actually seen as text? Because I can't just check them all by hand.
Thanks in advance
Comments
-
Hi @user046467
You could spin up a magic ETL and attempt to convert the data type to a date (using Alter Columns tile in Magic 2.0 or Data Type(?) in 1.0). When you run the preview it'll state which value it wasn't able to convert to a date.
Alternatively you could utilize a replace text field with a regular expression to change the text to a value if it passes and filter for rows which don't have the set value.
A simpler (but maybe less reliable) check would be to check to see if the length of your field is 10 characters or not (assuming YYYY-MM-DD type format - 8 digits, 2 separator characters) in a beast mode on a table card and then filter for records which don't have 10 digits.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
as an extension to @GrantSmith 's idea,
on your input tile in Magic 2.0 you can set the desired data type (instead of using an ALTER tile). you can also build in error handling that says 'if the column cannot be converted to date replace with a NULL value. You could then output rows where the date column is NULL as a dataset.
it's a bit of a pain to have a dataset with a null date column, so maybe add a ROW_ID so you at least know which row of your raw dataset it was.
i like your regex idea Grant! except i hate regex with a passion ?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive