Renaming columns with Date

Question

Hi I have a work flow where Month 1 is current Month, Month two is current Month + 1 and so on up until 30 months from now.

How do I rename these columns that Month 1 is July 2024, Month 2 is August 2024 and so on... but this is changing each month so next month when I run the report I would need month 1 to be August 2024, Month 2 to be September 2024 etc...

aatalai · Answer

@CM246 I would suggest an update of @DataNath 's solution using a dynamic rename use this

DateTimeFormat(
DateTimeAdd(
DateTimeToday(),
ToNumber(
Regex_Replace([_CurrentField_],'\D','')
)-1,
'month')
,'%B %Y') + Regex_Replace([_CurrentField_],'Month\s\d+','')

CM246 · Answer

Is there a way to replace anywhere it says Month 1, Month 2 etc?

The Fields aren't just Month 1, Month 2 but are:

Month 1 Open PO

Month 1 Finance Projection

Month 1 Planned Orders etc...

cjaneczko · Answer

Another way using the field info tool.

if [Name] = 'Month 1' then datetimeformat(datetimenow(),'%B %Y') elseif startswith([Name],'Month') then datetimeformat(datetimeadd(datetimeparse([Row-1:Date],'%B %Y'),1,'month'),'%B %Y') else [Name] endif