Hi,
How do I properly parse this data into Alteryx standards as I am having errors when using the formula tool and the datetime parse functions.
Thank you!
Posting Date |
Aug 14, 2023 |
Aug 15, 2023 |
Aug 2, 2023 |
Aug 2, 2023 |
Aug 14, 2023 |
Feb 6, 2023 |
Aug 14, 2023 |
Aug 14, 2023 |
Aug 15, 2023 |
Aug 15, 2023 |
Aug 15, 2023 |
Aug 15, 2023 |
Aug 14, 2023 |
Aug 14, 2023 |
Aug 14, 2023 |
Aug 14, 2023 |
Aug 14, 2023 |
Aug 15, 2023 |
Aug 15, 2023 |
Aug 14, 2023 |
Aug 15, 2023 |
Aug 14, 2023 |
Aug 15, 2023 |
Solved! Go to Solution.
Hi @esabay , the formula you need is:
datetimeparse([Posting Date],'%b %d, %Y')
Under Parse, there is the 'DateTime' tool.
Make sure the field you want to convert is a string.
Select the field in the DateTime tool. Select 'Custom' as the incoming string field type.
Then add the format to the bottom.
Alteryx should be able to covert the date into a useable format.
Edit: this is essentially doing the same thing as the formula posted above, just using a tool and UI.
Thank you, both!