Convert "25/Oct/21 11:00 AM" to "25/10/21"

[Silvia_Wu]

Hi!

I have the date format as "25/Oct/21 11:00 AM" as string. I want to convert it to "Date" as "25/10/21".

I tried DateTime to convert it, but it didn't work.

Any solutions?

Thank you in advance!

Kind regards,

Silvia

[JosephSerpis · Accepted solution]

Hi@Silvia_Wu I mocked up a workflow using the formula Datetimeformat and the specifiers from this page you can change your date into a format you desire. However if you perform this transformation your Date field will need to be a string field because the only format Alteryx regonises as a Date format is YYYY-MM-DD. You can also use the datetime tool to try this transformation as well.

[Silvia_Wu]

It works! Really appreciate your help!

Thank you!

Kind regards,

Silvia