Date conversion from excel

[aysha6029]

Hi Fiends,

I extract an excel sheet from an application on the below format. i need to convert the Date02 field to understandable format(ISO or USA Date format) from excel using alteryx. i request your help to help me solve this issue

S.No	Name	Date01	Date02
1	Holly	2009-09-30	40757
2	Peter	2009-08-25	40940
3	Sanson	2009-07-17	41306

[aysha6029]

Wow. Thats Works for me.. Thank You Marquee for helping me.

[aysha6029]

Hi JordanB,

Thank You for help. It works for me.