DATETIMEPARSE: Conversion Error Limit Reached
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello.
I have a sample file with multiple different date formats.
I'd like to convert all the date formats to the Alteryx date format.
For this, I wanted to use the Formula tool - and have a separate formula for each format:
However, I bump into this error:
DATETIMEPARSE: Conversion Error Limit Reached
I am aware of the DateTime Parse Tool, but it's not helping me, as it can only accept one format.
I assume that the moment this error exists, the work simply stops, which is why I get only null values after the first conversion.
Any help with this? (a workaround would be to check the format of each date via regex before using the datetimeparse(). But that is way longer)
Thanks!
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AmitMiller
Error spotting in your code, you're missing the second dot in the format if that helps?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nice catch!
But this doesn't resolve the main scenario. I will still bump into enough conversion errors to reach the limit, where the conversion will simply stop.
Not sure how to remove this limit. Or change my perspective.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you filter out the common date formats, use the required formula and then union back together?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I always understood the conversion error limit to be only for what was reported while the workflow was running, but you can change this in the Workflow Configuration window:
Stop processing is off by default i believe, if you're getting this stopping the workflow it must be switched on and you can up the number per location as well
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
