Date Formatting from "Text and Date" Value

[quims]

Hi Alteryx Community,

Would like to seek your assistance on how to convert into date format as dd-Mon-yyyy from both text and date value. I'm using "Date Time" under Parse but i still got an error.

Attached is my sample workflow.

Both date have different format, date and text.

 

 

[huynv96]

You can use BB Date tool here: https://community.alteryx.com/t5/Engine-Works-Blog/Introducing-BB-Date-Date-Parsing-for-the-Rest-of-...

Or using regex function to filter format date and parse them separately.

This workflow has two way above.

[DiegoParker · Accepted solution]

Hi @quims 

Please find my approach attached. The way I used is just using the datetimeparse function in the formula tool. The two calculations are:

1) DateTimeParse([Receipt Date],"%m-%d-%y")

2) if IsNull([DateParse]) then DateTimeParse([Receipt Date],"%y-%m-%d") else [DateParse] endif

One for eac date format.

Hope this helps If does, can I ask you to mark it as a solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego

[quims]

Thank you, @huynv96

Will keep this as a note for my future reference.

[quims]

Thank you, @DiegoParker 

This is very helpful. I was able to insert it into my workflow and running ok.