How do I properly parse this data?

[esabay]

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

[FinnCharlton · Accepted solution]

Hi @esabay , the formula you need is:

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

[EdwardCochrane · Accepted solution]

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]

Thank you, both!