How do I properly parse this data?

Question

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 DateAug 14, 2023Aug 15, 2023Aug 2, 2023Aug 2, 2023Aug 14, 2023Feb 6, 2023Aug 14, 2023Aug 14, 2023Aug 15, 2023Aug 15, 2023Aug 15, 2023Aug 15, 2023Aug 14, 2023Aug 14, 2023Aug 14, 2023Aug 14, 2023Aug 14, 2023Aug 15, 2023Aug 15, 2023Aug 14, 2023Aug 15, 2023Aug 14, 2023Aug 15, 2023

FinnCharlton · Accepted Answer

Hi @esabay , the formula you need is:

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

EdwardCochrane · Accepted Answer

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.