Dynamic Renaming For Header Renaming

[Alteryxexpert]

Hi I have a data column like below, Which has the header like 2024-07-22 and this header will change daily. I want to rename the column to (Sales ($m) July 22, 2024). How to do this using Alteryx Dynamic renaming?

Current column

Current Column name	Expected Output
2024-07-22	Sales ($m) July 22, 2024

[flying008]

Hi, @Alteryxexpert 

FYI.

[dkungu]

Hi @Alteryxexpert 

You can use dynamic rename for this.

[Alteryxexpert]

I don't want to use Date time now function, I want just to rename 2024-07-22 to Sales ($m) July 22,2024