No Idea why I can't get string to datetime
Best Answer
-
A good place to try out the function is at W3Schools site.
I took your sample date and the format you want and it worked.
This makes me think you have some extra data coming in on some of your rows that is causing the issue. In your error message you have a / . Where is that coming from?
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
A good place to try out the function is at W3Schools site.
I took your sample date and the format you want and it worked.
This makes me think you have some extra data coming in on some of your rows that is causing the issue. In your error message you have a / . Where is that coming from?
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
No Idea where this is coming from. I'm not super great with SQl, and it's my first week with Domo.
0 -
Here is one way to troubleshoot. Create a table card and drag in your timein1 field. Drag it in a 2nd time and change the aggregation to count. This will give you a distinct list of date/times in your dataset.
Next, create a beastmode that looks like this:
TRY_CAST(timein1 as datetime)
Drag this field into your table card. Scroll through the list and look for where this field is showing as blank. This means that Domo wasn't able to convert this to a valid date/time. Look at the timein1 field next to it and see what looks odd about it that it can't convert and make any adjustments. As an example, you may need to use a REPLACE function to remove a / if that is in that field.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Found it. Bad incoming data. On a rare occasion 05:30pm was input as 5:30pm. Messed the whole thing up.Thanks for the assist though!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 730 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive