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.

Sample Date.xlsx

Date Formatting.yxmd

DiegoParker

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

Date Formatting.yxmd