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 DateOutput Date19th October 202019-10-202022nd November 202022-11-20205th April 202205-04-2020 Can anyone help me to resolve this problem? If possible kindly attach the sample WF as well.

Channing Of Date Format

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.

Datasets

Date Time

Data Investigation

Accepted answers

Qiu

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

0412-shashank_shukla.yxmd

All comments

binu_acs

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

convertDate.yxmd

Qiu

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

0412-shashank_shukla.yxmd

shashank_shukla

Hey @binu_acs ,

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. 👍

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703