Parse the date between the spaces and convert to date format using formula tool

Question

Hi I have a date data like this "Thursday 01/04/2021 01:50:39" (without quotations) and I wanted to make sure that it is displayed like "01/04/2021" (without quotations) and converted to Date format. I have several columns with similar format, and in order to keep workflow simple, I am looking for a solution to achieve the desired result with a Formula tool. Can anyone help me with this?

DavidP · Answer

There are also other fun things you can do with Text functions, for instance, if the Getword() function looks a your string, it would see 3 words (numbered 0,1,2)  You can therefore extract the middle word from the string (which is the date part) using GetWord(string, 1)

If you then want to convert that to an Alteryx date format, the DatetimeParse() function becomes a little easier to implement.

messi007 · Answer

@phajiyev,

Please see below :

Attached the workflow,

Regards,

ConvertDate_20220429.yxmd

binu_acs · Answer

@phajiyev You can achieve this with the help of Formula tool or the DateTime tool

DateFormat_28_04.yxmd