Alteryx Designer Desktop Discussions

esabay · ‎08-21-2023

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 14, 2023

Feb 6, 2023

Aug 14, 2023

Aug 15, 2023

Aug 14, 2023

Aug 15, 2023

Aug 14, 2023

Aug 15, 2023

Aug 14, 2023

Aug 15, 2023

FinnCharlton · ‎08-21-2023

Hi @esabay , the formula you need is:

datetimeparse([Posting Date],'%b %d, %Y')

EdwardCochrane · ‎08-21-2023

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.

esabay · ‎09-06-2023

Thank you, both!

How do I properly parse this data?