RENAME THE FIELD BASED ON DATES

[Ronal_bal]

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 solution]

Hey @Ronal_bal, this expression ought to do it:

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

[npariso]

Hi @Ronal_bal here is the formula that will get you to your solution.

IF [_CurrentField_] < DateTimeNow()
THEN "Actual "+[_CurrentField_]
ELSE [_CurrentField_]
ENDIF