Renaming column headers dynamically

[Alteryxexpert]

I have Data like below

Item	2023_12_31	2024_01_31	2024_02_29	2024_03_31	2024_04_30
A	45656	652132	3623626	2626	26
B	78789	9555	98555	666	12345
C	45656	652132	3623626	2626	26
D	78789	9555	98555	666	12345
E	45656	652132	3623626	2626	26

I need the columns 2023_12_31 and other columns to be renamed as 31-Dec-2023,31-Jan-2024 and so on for all the upcoming columns. How to achieve this?

[SPetrie]

A field info tool to get the existing field names. Convert the dates to the format you want and then a dynamic rename tool to update them.

The attached workflow should do what you need.

[DataNath]

Hey @Alteryxexpert, can also do this directly using the 'Formula' rename mode:

DateTimeFormat(DateTimeParse([_CurrentField_],'%Y_%m_%d'),'%d-%b-%y')

[SPetrie]

I want to change my answer to what @DataNath has. I completely blanked on that. Go with their answer lol.