Date Format Conversion

[YLYONG]

Hi All,

I am looking to convert a string field that is actually a date to a specific format:

Managed to split the time, however the month is "OCT" instead of "10"

Thanks in advance for the help.

Input

DATE_REC

25/OCT/21 12:00:00 AM

26/OCT/21 12:00:00 AM

27/OCT/21 12:00:00 AM

28/OCT/21 12:00:00 AM

29/OCT/21 12:00:00 AM

30/OCT/21 12:00:00 AM

01/NOV/21 12:00:00 AM

02/NOV/21 12:00:00 AM

03/NOV/21 12:00:00 AM

Output

DATE_REC

25/10/2021

26/10/2021

27/10/2021

28/10/2021

29/10/2021

30/10/2021

1/11/2021

2/11/2021

3/11/2021

[YLYONG]

all good, solution found

[Qiu · Accepted solution]

@YLYONG 
I dont think that is the same solution as you requested. 😁
have the RegEx from here

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Remove-Leading-Zeroes-in-days-and-mont...

[YLYONG]

@Qiu Thank you, this works as well!

[Qiu]

@YLYONG 
Thank you for the accept mark as well.