Channing Of Date Format

[shashank_shukla]

Hello All,

Scenario:- 

I am fetching a data from Excel file and in the file one of the Date column is present which is in String format and I have to convert that into default date format of Alteryx.

Input Date	Output Date
19th October 2020	19-10-2020
22nd November 2020	22-11-2020
5th April 2022	05-04-2020

Can anyone help me to resolve this problem?

If possible kindly attach the sample WF as well.

[binuacs]

@shashank_shukla one way of doing this by checking the 'th' and 'nd' after the day

[Qiu · Accepted solution]

@shashank_shukla 
I remove the "nd", "st" or "rd" with a RegEx formulathen do the DateTimeParse as below

  

[shashank_shukla]

Hey @binuacs ,

Thank you very much for quick reply I tried your solution and its worked very well for me.

Thank you very much for help.

Have a great day ahead of you.

[shashank_shukla]

Hello @Qiu ,

Thank you very much for providing the solution.

Your solution is also working fine with me.

Thank you very much for providing the different way of solution.

Have A Great Day Ahead Of You.

[Qiu]

@shashank_shukla 
Thank you very much for the feedback and glad to be helpful. 👍