How to change column header name (todays date) to a string like "Todays Sales"

[Anjankumar2021]

I am a new user to Alteryx designer. not able to fix below exception. Every day this column header name changes to present date( todays date) . want to Change Column header (2022-12-12) name is todays date to "Today Sales". 

Please help me:)

[ShankerV]

Hi @Anjankumar2021 

You can use the Dynamic Rename to achieve your solution.

Many thanks

Shanker V

[ShankerV]

Hi @Anjankumar2021 

Please find the below solution for you.

IF Contains([_CurrentField_], datetimeformat(DateTimeToday(),"%d/%m/%Y")) THEN
"Today Sales"
ELSE [_CurrentField_]
ENDIF

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Anjankumar2021 

Input was:

Output as expected:

Designed the formula in such a way it will work dynamically for all the days you run in future,

IF Contains([_CurrentField_], datetimeformat(DateTimeToday(),"%d/%m/%Y")) THEN
"Today Sales"
ELSE [_CurrentField_]
ENDIF

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[binuacs · Accepted solution]

@Anjankumar2021 One way of doing this

[Anjankumar2021]

@binuacs -Thank you so much for your help and its working fine to me 😊