Add new field with Date

[wendyzjy]

hello experts！

I would like to change filed with the update period name, for example, in August, I want to change the name with "July 2022", and once I am in September, and when I run the workflow, I want to change the column name as "August 2022". The month and year should update month over month. Please help advise. Thanks! 

[Qiu]

@wendyzjy 
We can use the DateTimeNow function to get the current date, then do some calculation and formatting.

[wendyzjy]

This could be a solution, but I actually would like to change the column name only but not the field values. Should I should Multi-Row Tool? 

[Amol_Telore · Accepted solution]

Hey @wendyzjy 

You can use dynamic rename tool to rename field name using formula as per your needs. Hope this solves your concern.

[liwagab]

using datetimenow() function in the formula tool should complete your requirement

output would be dynamic based on the month you are running the workflow.

[wendyzjy]

Thanks!