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:)
Solved! Go to Solution.
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
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 -Thank you so much for your help and its working fine to me 😊