RENAME THE FIELD BASED ON DATES

Question

Hi,

I've many fields with dates as there header.

eg: attached screenshot.

I want create a formula in dynamic rename tool which will add the word 'actual' to the prefix of the dates which are less than today's date.

any help will be grate

DataNath · Accepted Answer

Hey @Ronal_bal, this expression ought to do it:

IF [_CurrentField_] < DateTimeToday() THEN 'Actual_'+[_CurrentField_] ELSE [_CurrentField_] ENDIF