Date Conversion not working
- 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
Hi folks - I'm trying to convert a date in my workflow that is coming from an Excel source as 20210501. Alteryx is bringing the field in a a V_String.
I was trying to use a formula tool with the ToDate() function but my output is coming out Null. Is there a better way to handle this?
Thanks! George
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @George_Fischetti ,
There is a way easier way to do it:
The DateTime block, that it in the parse category.
Also you could look into the one tool example to see how it is used.
Here are the options:
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's two different approaches, one with the datetime tool mentioned above, and one with the date time parse function.
I suggest bookmarking this page, it is invaluable when working with dates and alteryx date functions: DateTime Functions | Alteryx Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you both for your input - the formula tool with the datetimeparse function worked best!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
